APPS.BOM_IMPORT_PUB dependencies on EGO_IMPORT_BATCHES_B

Line 379: FROM EGO_IMPORT_BATCHES_B

375: THEN
376: BEGIN
377: SELECT 'Exist'
378: INTO l_dummy
379: FROM EGO_IMPORT_BATCHES_B
380: WHERE batch_id = p_batch_id
381: AND batch_type = 'BOM_STRUCTURE';
382:
383: EXCEPTION

Line 521: EGO_IMPORT_BATCHES_B b, ego_import_option_sets o

517: NVL(o.CHANGE_ORDER_CREATION, 'I'), --I, ignore change,
518: DECODE(NVL(b.SOURCE_SYSTEM_ID,0), G_PDH_SRCSYS_ID, 'Y', 'N'),
519: o.add_all_to_change_flag
520: FROM
521: EGO_IMPORT_BATCHES_B b, ego_import_option_sets o
522: WHERE
523: b.BATCH_ID = o.BATCH_ID
524: AND b.BATCH_ID = p_batch_id;
525: BEGIN

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

Line 1702: ego_import_batches_b EIBB

1698: UPPER(BBMI.TRANSACTION_TYPE),
1699: BBMI.ITEM_DESCRIPTION
1700: FROM
1701: bom_bill_of_mtls_interface BBMI,
1702: ego_import_batches_b EIBB
1703: WHERE
1704: BBMI.batch_id = l_batch_id
1705: AND EIBB.batch_id = BBMI.batch_id
1706: AND BBMI.PROCESS_FLAG NOT IN (3,7,-1);

Line 1728: ego_import_batches_b EIBB

1724: UPPER(BICI.TRANSACTION_TYPE),
1725: BICI.ITEM_DESCRIPTION
1726: FROM
1727: bom_inventory_comps_interface BICI,
1728: ego_import_batches_b EIBB
1729: WHERE
1730: BICI.batch_id = l_batch_id
1731: AND EIBB.batch_id = BICI.batch_id
1732: AND BICI.PROCESS_FLAG NOT IN (3,7,-1);

Line 2717: ego_import_batches_b

2713: source_system_id
2714: INTO
2715: l_source_system_id
2716: FROM
2717: ego_import_batches_b
2718: WHERE
2719: batch_id = p_batch_id;
2720:
2721: EXCEPTION

Line 3541: EGO_IMPORT_BATCHES_B

3537: l_conc_status BOOLEAN;
3538: BEGIN
3539: IF (p_batch_id IS NOT NULL) THEN
3540: SELECT batch_id INTO l_batch_metadata_exists FROM
3541: EGO_IMPORT_BATCHES_B
3542: WHERE BATCH_ID = p_batch_id;
3543: IF (l_batch_metadata_exists IS NOT NULL) THEN
3544: x_return_code := 'E';
3545: x_err_buffer := FND_MESSAGE.GET_STRING(G_APP_SHORT_NAME,'BOM_BATCH_EXIST');