Interface Tables in Oracle Applications

 Interface tables, Main Tables and seeded Programs

1. Oracle Bill of Material Interface
Program Name : Bill and Routing Interface
                                    
Interface Tables
1. BOM_BILL_OF_MTLS_INTERFACE
2. BOM_INVENTORY_COMPS_INTERFACE
3. BOM_REF_DESGS_INTERFACE
4. BOM_SUB_COMPS_INTERFACE
5. MTL_ITEM_REVISIONS_INTERFACE

Main Tables
1. bom_bill_of_materials
2. bom_inventory_components
3. bom_reference_designators
4. bom_substitute_components
5. mtl_item_revisions

2. Oracle Routing Interface
Program Name : Bill and Routing Interface

Interface Tables
1. BOM_OP_ROUTINGS_INTERFACE
2. BOM_OP_SEQUENCES_INTERFACE
3. BOM_OP_RESOURCES_INTERFACE
4. MTL_RTG_ITEM_REVS_INTERFACE

Main Tables 
1. bom_operational_routings
2. bom_operation_sequences
3. bom_operation_resources

   3. Supplier Interface
Program Name : Supplier Open Interface Import

Interface Tables
1. AP_SUPPLIERS_INT

Main Tables 
1. AP_SUPPLERS

                                                            4. Supplier Site Interface
Program Name : Supplier Sites Open Interface Import

Interface Tables
1. AP_SUPPLIER_SITES_INT

Main Tables
1. AP_SUPPLER_SITES_ALL

                                                             5. Supplier Contact Interface
Program Name : Supplier Site Contacts Open Interface Import

Interface Tables
1.AP_SUP_SITE_CONTACT_INT

Main Tables
1. AP_SUPPLIER_CONTACTS



                                                            6. Requisitions Interface 
Program Name: Requisition Import

Interface Tables

1. PO_REQUISITIONS_INTERFACE

2. PO_REQ_DIST_INTERFACE

Main Tables

1. PO_REQUISITION_HEADERS

2. PO_REQUISITION_LINES

                                                          7. Purchase Order Interface

Program Name: For Blanket PO - Import Price Catalogs
Program Name : For Standard PO - Import Standard Purchase Orders

Interface Tables

1. PO_HEADERS_INTERFACE

2. PO_LINES_INTERFACE

Main Tables

1. PO_HEADERS_ALL

2. PO_LINES_ALL

3. PO_LINE_LOCATIONS_ALL

4. PO_DISTRIBUTIONS_ALL

                                                             8. Receiving Interface

Program Name : Receiving Transaction Processor

Interface Tables

1. RCV_HEADERS_INTERFACE

2. RCV_TRANSACTIONS_INTERFACE

Main Tables

1. RCV_TRANSACTIONS

2. RCV_TRANSACTION_HEADERS

3. RCV_TRANSACTION_LINES

                                                    9. Payables Interface
Program Name : Payables Open Interface Import

Interface Tables

1. AP_INVOICE_HEADERS_INTERFACE

2. AP_INVOICE_LINES_INTERFACE

Base Tables

1. AP_INVOICE_HEADERS_ALL

2. AP_INVOICE_LINES_ALL

3. AP_INVOICE_DISTRIBUTIONS_ALL