APPS.BOM_EXPLODER_PUB dependencies on EGO_ITEMS_V

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

1165: */
1166: AND BET.LOOP_FLAG = 2
1167: AND ( filter_pbom IS NULL
1168: OR
1169: EXISTS (SELECT null FROM ego_items_v WHERE inventory_item_id = BIC.component_item_id AND
1170: organization_id = NVL(BET.COMMON_ORGANIZATION_ID,BET.ORGANIZATION_ID) AND
1171: TRADE_ITEM_DESCRIPTOR IS NOT NULL)
1172: )
1173: /*

Line 1920: FROM ego_items_v egi

1916: , eng_item_flag_tbl(i)
1917: , primary_uom_desc_tbl(i)
1918: , trade_item_descriptor_desc_tbl(i)
1919: ,gtin_publication_status_tbl(i)
1920: FROM ego_items_v egi
1921: WHERE inventory_item_id = component_item_id_tbl(i)
1922: --AND organization_id = nvl(common_organization_id_tbl(i),organization_id_tbl(i));
1923: AND organization_id = common_organization_id_tbl(i);
1924: ELSE

Line 3489: FROM ego_items_v eiv

3485: pk_value3,
3486: pk_value4,
3487: pk_value5,
3488: 'Y'
3489: FROM ego_items_v eiv
3490: where
3491: eiv.inventory_item_id = item_id
3492: AND eiv.organization_id = org_id);
3493:

Line 3834: FROM ego_items_v egi

3830:
3831: UPDATE BOM_EXPLOSIONS_ALL
3832: 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) =
3833: (SELECT gtin, description, trade_item_descriptor, gtin, description, trade_item_descriptor, trade_item_descriptor_desc, publication_status
3834: FROM ego_items_v egi
3835: WHERE inventory_item_id = item_id AND organization_id = org_id)
3836: WHERE group_id = grp_id
3837: AND sort_order = '0000001';
3838: