APPS.BOM_IMPORT_PUB dependencies on EGO_IMPORT_OPTION_SETS

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

1625: TYPE num_type IS TABLE OF NUMBER;
1626:
1627: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;
1628: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;
1629: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;
1630:
1631: l_header_table bom_intf_header;
1632: l_comp_table bom_intf_comp;
1633: l_header_count NUMBER;

Line 1678: ego_import_option_sets

1674: structure_type_id,
1675: structure_name,
1676: structure_effectivity_type
1677: FROM
1678: ego_import_option_sets
1679: WHERE
1680: batch_id = p_batch_id;
1681:
1682: CURSOR Upload_Header

Line 1740: FROM ego_import_option_sets

1736: l_batch_id IN NUMBER
1737: )
1738: IS
1739: SELECT *
1740: FROM ego_import_option_sets
1741: WHERE batch_id = l_batch_id;
1742:
1743: BEGIN
1744: IF p_init_msg_list = 'Y'

Line 4029: FROM ego_import_option_sets

4025:
4026: CURSOR Get_Change_Option
4027: IS
4028: SELECT add_all_to_change_flag
4029: FROM ego_import_option_sets
4030: WHERE batch_id = p_batch_id;
4031:
4032: BEGIN
4033: