APPS.BOM_GTIN_RULES dependencies on EGO_ITEMS_V

Line 148: FROM bom_components_b bic, ego_items_v egi

144:
145: CURSOR c_gtin_count(p_bill_sequence_id IN NUMBER) IS
146: SELECT count(DISTINCT egi.trade_item_descriptor) distinct_trade_count, count(DISTINCT egi.gtin) gtin_count,
147: count(egi.trade_item_descriptor) total_trade_count
148: FROM bom_components_b bic, ego_items_v egi
149: WHERE bic.bill_sequence_id = p_bill_sequence_id AND
150: bic.pk1_value = egi.inventory_item_id AND
151: bic.pk2_value = egi.organization_id AND
152: bic.effectivity_date <= SYSDATE AND

Line 176: FROM ego_items_v

172: /* Get the parent gtin, parent tid, published status, top_gtin flag value for the parent */
173:
174: SELECT gtin,trade_item_descriptor,publication_status, top_gtin, primary_uom_code
175: INTO l_parent_gtin, l_parent_tid, l_publication_status, l_top_gtin, l_parent_uom_code
176: FROM ego_items_v
177: WHERE inventory_item_id = p_assembly_item_id AND
178: organization_id = p_organization_id;
179:
180: /* Get the componet gtin, component tid value for the component */

Line 184: FROM ego_items_v

180: /* Get the componet gtin, component tid value for the component */
181:
182: SELECT gtin, trade_item_descriptor, primary_uom_code
183: INTO l_component_gtin, l_component_tid, l_child_uom_code
184: FROM ego_items_v
185: WHERE inventory_item_id = p_component_item_id AND
186: organization_id = p_organization_id;
187:
188: