APPS.BOM_GTIN_RULES dependencies on BOM_COMPONENTS_B

Line 64: FROM bom_components_b

60: AND alternate_bom_designator = 'PIM_PBOM_S';
61:
62: CURSOR Pack_Comp_Exist(l_bill_seq_id IN NUMBER) IS
63: SELECT 'Exist'
64: FROM bom_components_b
65: WHERE bill_sequence_id = l_bill_seq_id
66: AND (disable_date IS NULL OR disable_date > sysdate);
67:
68: TYPE var_type IS TABLE OF VARCHAR2(20);

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