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 173: FROM ego_items_v

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

Line 181: FROM ego_items_v

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