APPS.BOM_IMPORT_PUB dependencies on MTL_CROSS_REFERENCES

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

1050: /****************** Resolve Cross References **************************
1051: * Procedure : RESOLVE_XREFS_FOR_BATCH
1052: * Purpose : This procedure will update the Bom Structure and Components
1053: * Interface tables with the cross reference data obtained from
1054: * Mtl_Cross_References.This API will update the Cross Referenced data
1055: * for record in a batch which have matching entries in
1056: * Mtl_Cross_References table.
1057: * ??This should also insert customer xrefed rows
1058: * Will return with success for Xreferences only

Line 1056: * Mtl_Cross_References table.

1052: * Purpose : This procedure will update the Bom Structure and Components
1053: * Interface tables with the cross reference data obtained from
1054: * Mtl_Cross_References.This API will update the Cross Referenced data
1055: * for record in a batch which have matching entries in
1056: * Mtl_Cross_References table.
1057: * ??This should also insert customer xrefed rows
1058: * Will return with success for Xreferences only
1059: **********************************************************************/
1060:

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

1080:
1081: CURSOR Process_Header(l_batch_id IN NUMBER)
1082: IS
1083: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
1084: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1085: WHERE BBMI.batch_id = l_batch_id
1086: AND EIBB.batch_id = BBMI.batch_id
1087: AND MCR.source_system_id = EIBB.source_system_id
1088: AND MCR.cross_reference = BBMI.source_system_reference

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

1094:
1095: CURSOR Process_Comp(l_batch_id IN NUMBER)
1096: IS
1097: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1098: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1099: WHERE BICI.batch_id = l_batch_id
1100: AND EIBB.batch_id = BICI.batch_id
1101: AND MCR.source_system_id = EIBB.source_system_id
1102: AND MCR.cross_reference = BICI.comp_source_system_reference

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

1108:
1109: CURSOR Process_Header_For_Comp
1110: IS
1111: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1112: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1113: WHERE BICI.batch_id = p_batch_id
1114: AND EIBB.batch_id = BICI.batch_id
1115: AND MCR.source_system_id = EIBB.source_system_id
1116: AND MCR.cross_reference = BICI.parent_source_system_reference