p2p interface names

1)Inventory
==============

Item import (Item conversion):
=====================================

Interface tables
=================

insert into MTL_SYSTEM_ITEMS_INTERFACE
                   (
                      ORGANIZATION_CODE,
                      TEMPLATE_NAME,
                      SEGMENT1,
                      Description,
                      PROCESS_FLAG,
                      TRANSACTION_TYPE,
                      PRIMARY_UNIT_OF_MEASURE
                    )
           values
                   (
                        'V1',
                        'Purchased Item',
                        'NLM0037',
                        'Laptop',
                        1,
                        'CREATE',
                        'Each'
                     )  
                       
                       
select * from mtl_item_templates_b  

select * from mtl_system_items_b     

Run program ===> inventory==>items ==>import ==> import items==> (IMPORT ITEMS)

APi
========
EGO_ITEM_PUB.process_items


2)Onhand Quantity
==========================

Interface tables:
====================

MTL_TRANSACTIONS_INTERFACE

MTL_MTL_TRANSACTION_LOTS_INTERFACE (If the item is Lot controlled)

MTL_SERIAL_NUMBERS_INTERFACE (If the item is Serial controlled)

Concurrent Program:-inventory=>setup=>Transactions=>Interface Manger=>put cursor on Material Transaction=>
                    tools=>Launch Manager=>(Process Transaction Interface)

INSERT INTO mtl_transactions_interface
                (source_code
                ,source_line_id
                ,source_header_id
                ,process_flag
                ,transaction_mode               
                ,organization_id
                ,transaction_quantity
                ,transaction_uom
                ,transaction_date
                ,transaction_type_id
                ,inventory_item_id
                ,subinventory_code
                ,distribution_account_id
                ,transaction_interface_id             
                )
            VALUES('Inventory',
                0,
                0,
                1,
                3,              
                204,
                10,
                'Ea',
                SYSDATE,
                42    ,
                248200,
                 FGI,
                13401,
                MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL              
            );
           

select * from mtl_system_items_b where segment1='SAN001'

Requistion Interface
==============================

Interface Tables:--
-------------------------
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL   

Base tables:--
----------------
PO_REQUISITIONS_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL

Concurrent program:--
----------------------
REQUISITION IMPORT   

PO_REQUISITIONS_INTERFACE_ALL:
=====================================
INTERFACE_SOURCE_CODE (to identify the source of your imported Requisitions)
DESTINATION_TYPE_CODE
AUTHORIZATION_STATUS
PREPARER_ID or PREPARER_NAME
QUANTITY
CHARGE_ACCOUNT_ID or charge account segment values
DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE
DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE
DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME
ORG_ID
ITEM_ID or item segment values (values if the SOURCE_TYPE_CODE or
DESTINATION_TYPE_CODE is ‘INVENTORY’)

PO_REQ_DIST_INTERFACE_ALL:
===================================
CHARGE_ACCOUNT_ID or charge account segment values
DISTRIBUTION_NUMBER
DESTINATION_ORGANIZATION_ID
DESTINATION_TYPE_CODE
INTERFACE_SOURCE_CODE
ORG_ID
DIST_SEQUENCE_ID


API
======
PO_REQUISITION_HEADERS_PKG.Insert_Row


select * from po_requisition_headers_all where segment1='14466' and TYPE_LOOKUP_CODE='PURCHASE'


select * from po_headers_all where segment1='6543' and  TYPE_LOOKUP_CODE='STANDARD'

select * from po_lines_all where PO_HEADER_ID=112400


select * from rcv_shipment_headers where RECEIPT_NUM='12236' and SHIP_TO_ORG_ID=209

select * from ap_invoices_all where INVOICE_NUM='KBH123'


IBY_VALIDATIONSETS_PUB