APPS.BOM_IMPORT_PUB dependencies on MTL_CROSS_REFERENCES

Line 913: * Mtl_Cross_References.This API will update the Cross Referenced data

909: /****************** Resolve Cross References **************************
910: * Procedure : RESOLVE_XREFS_FOR_BATCH
911: * Purpose : This procedure will update the Bom Structure and Components
912: * Interface tables with the cross reference data obtained from
913: * Mtl_Cross_References.This API will update the Cross Referenced data
914: * for record in a batch which have matching entries in
915: * Mtl_Cross_References table.
916: * ??This should also insert customer xrefed rows
917: * Will return with success for Xreferences only

Line 915: * Mtl_Cross_References table.

911: * Purpose : This procedure will update the Bom Structure and Components
912: * Interface tables with the cross reference data obtained from
913: * Mtl_Cross_References.This API will update the Cross Referenced data
914: * for record in a batch which have matching entries in
915: * Mtl_Cross_References table.
916: * ??This should also insert customer xrefed rows
917: * Will return with success for Xreferences only
918: **********************************************************************/
919:

Line 943: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

939:
940: CURSOR Process_Header(l_batch_id IN NUMBER)
941: IS
942: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
943: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
944: WHERE BBMI.batch_id = l_batch_id
945: AND EIBB.batch_id = BBMI.batch_id
946: AND MCR.source_system_id = EIBB.source_system_id
947: AND MCR.cross_reference = BBMI.source_system_reference

Line 957: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

953:
954: CURSOR Process_Comp(l_batch_id IN NUMBER)
955: IS
956: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
957: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
958: WHERE BICI.batch_id = l_batch_id
959: AND EIBB.batch_id = BICI.batch_id
960: AND MCR.source_system_id = EIBB.source_system_id
961: AND MCR.cross_reference = BICI.comp_source_system_reference

Line 971: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

967:
968: CURSOR Process_Header_For_Comp
969: IS
970: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
971: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
972: WHERE BICI.batch_id = p_batch_id
973: AND EIBB.batch_id = BICI.batch_id
974: AND MCR.source_system_id = EIBB.source_system_id
975: AND MCR.cross_reference = BICI.parent_source_system_reference