APPS.BOM_EXPLODER_PUB dependencies on EGO_ITEMS_V

Line 1091: EXISTS (SELECT null FROM ego_items_v WHERE inventory_item_id = BIC.component_item_id AND

1087: */
1088: AND BET.LOOP_FLAG = 2
1089: AND ( filter_pbom IS NULL
1090: OR
1091: EXISTS (SELECT null FROM ego_items_v WHERE inventory_item_id = BIC.component_item_id AND
1092: organization_id = NVL(BET.COMMON_ORGANIZATION_ID,BET.ORGANIZATION_ID) AND
1093: TRADE_ITEM_DESCRIPTOR IS NOT NULL)
1094: )
1095: /*

Line 1839: FROM ego_items_v egi

1835: , eng_item_flag_tbl(i)
1836: , primary_uom_desc_tbl(i)
1837: , trade_item_descriptor_desc_tbl(i)
1838: ,gtin_publication_status_tbl(i)
1839: FROM ego_items_v egi
1840: WHERE inventory_item_id = component_item_id_tbl(i)
1841: --AND organization_id = nvl(common_organization_id_tbl(i),organization_id_tbl(i));
1842: AND organization_id = common_organization_id_tbl(i);
1843: ELSE

Line 3375: FROM ego_items_v eiv

3371: pk_value3,
3372: pk_value4,
3373: pk_value5,
3374: 'Y'
3375: FROM ego_items_v eiv
3376: where
3377: eiv.inventory_item_id = item_id
3378: AND eiv.organization_id = org_id);
3379:

Line 3719: FROM ego_items_v egi

3715:
3716: UPDATE BOM_EXPLOSIONS_ALL
3717: SET (gtin_number, gtin_description, trade_item_descriptor, top_gtin_number, top_gtin_description, top_trade_item_descriptor, trade_item_descriptor_desc, gtin_publication_status) =
3718: (SELECT gtin, description, trade_item_descriptor, gtin, description, trade_item_descriptor, trade_item_descriptor_desc, publication_status
3719: FROM ego_items_v egi
3720: WHERE inventory_item_id = item_id AND organization_id = org_id)
3721: WHERE group_id = grp_id
3722: AND sort_order = '0000001';
3723: