APPS.BOM_IMPORT_PUB dependencies on EGO_IMPORT_BATCHES_B

Line 386: FROM EGO_IMPORT_BATCHES_B

382: THEN
383: BEGIN
384: SELECT 'Exist'
385: INTO l_dummy
386: FROM EGO_IMPORT_BATCHES_B
387: WHERE batch_id = p_batch_id
388: AND batch_type = 'BOM_STRUCTURE';
389:
390: EXCEPTION

Line 528: EGO_IMPORT_BATCHES_B b, ego_import_option_sets o

524: NVL(o.CHANGE_ORDER_CREATION, 'I'), --I, ignore change,
525: DECODE(NVL(b.SOURCE_SYSTEM_ID,0), G_PDH_SRCSYS_ID, 'Y', 'N'),
526: o.add_all_to_change_flag
527: FROM
528: EGO_IMPORT_BATCHES_B b, ego_import_option_sets o
529: WHERE
530: b.BATCH_ID = o.BATCH_ID
531: AND b.BATCH_ID = p_batch_id;
532: BEGIN

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

Line 1845: ego_import_batches_b EIBB

1841: UPPER(BBMI.TRANSACTION_TYPE),
1842: BBMI.ITEM_DESCRIPTION
1843: FROM
1844: bom_bill_of_mtls_interface BBMI,
1845: ego_import_batches_b EIBB
1846: WHERE
1847: BBMI.batch_id = l_batch_id
1848: AND EIBB.batch_id = BBMI.batch_id
1849: AND BBMI.PROCESS_FLAG NOT IN (3,7,-1);

Line 1871: ego_import_batches_b EIBB

1867: UPPER(BICI.TRANSACTION_TYPE),
1868: BICI.ITEM_DESCRIPTION
1869: FROM
1870: bom_inventory_comps_interface BICI,
1871: ego_import_batches_b EIBB
1872: WHERE
1873: BICI.batch_id = l_batch_id
1874: AND EIBB.batch_id = BICI.batch_id
1875: AND BICI.PROCESS_FLAG NOT IN (3,7,-1);

Line 2870: ego_import_batches_b

2866: source_system_id
2867: INTO
2868: l_source_system_id
2869: FROM
2870: ego_import_batches_b
2871: WHERE
2872: batch_id = p_batch_id;
2873:
2874: EXCEPTION

Line 3933: EGO_IMPORT_BATCHES_B

3929: l_conc_status BOOLEAN;
3930: BEGIN
3931: IF (p_batch_id IS NOT NULL) THEN
3932: SELECT batch_id INTO l_batch_metadata_exists FROM
3933: EGO_IMPORT_BATCHES_B
3934: WHERE BATCH_ID = p_batch_id;
3935: IF (l_batch_metadata_exists IS NOT NULL) THEN
3936: x_return_code := 'E';
3937: x_err_buffer := FND_MESSAGE.GET_STRING(G_APP_SHORT_NAME,'BOM_BATCH_EXIST');