APPS.BOM_IMPORT_PUB dependencies on EGO_IMPORT_OPTION_SETS

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 1772: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;

1768: TYPE num_type IS TABLE OF NUMBER;
1769:
1770: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;
1771: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;
1772: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;
1773:
1774: l_header_table bom_intf_header;
1775: l_comp_table bom_intf_comp;
1776: l_header_count NUMBER;

Line 1821: ego_import_option_sets

1817: structure_type_id,
1818: structure_name,
1819: structure_effectivity_type
1820: FROM
1821: ego_import_option_sets
1822: WHERE
1823: batch_id = p_batch_id;
1824:
1825: CURSOR Upload_Header

Line 1883: FROM ego_import_option_sets

1879: l_batch_id IN NUMBER
1880: )
1881: IS
1882: SELECT *
1883: FROM ego_import_option_sets
1884: WHERE batch_id = l_batch_id;
1885:
1886: BEGIN
1887: IF p_init_msg_list = 'Y'

Line 4421: FROM ego_import_option_sets

4417:
4418: CURSOR Get_Change_Option
4419: IS
4420: SELECT add_all_to_change_flag
4421: FROM ego_import_option_sets
4422: WHERE batch_id = p_batch_id;
4423:
4424: BEGIN
4425: