APPS.BOM_TA_EXCLUSIONS_PVT dependencies on BOM_INVENTORY_COMPONENTS

Line 11: FROM bom_inventory_components

7: l_comp_item_id Number;
8:
9: CURSOR C_bic(p_comp_seq_id Number) IS
10: SELECT bill_sequence_id,component_item_id
11: FROM bom_inventory_components
12: WHERE component_sequence_id = p_del_comp_seq;
13:
14: BEGIN
15:

Line 29: FROM BOM_INVENTORY_COMPONENTS

25: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
26: WHERE COMPONENT_ITEM_ID = l_comp_item_id
27: AND PARENT_BILL_SEQ_ID = l_bill_seq_id
28: AND 1 = (SELECT COUNT(*)
29: FROM BOM_INVENTORY_COMPONENTS
30: WHERE COMPONENT_ITEM_ID = l_comp_item_id
31: AND BILL_SEQUENCE_ID = l_bill_seq_id)
32: );
33:

Line 41: FROM BOM_INVENTORY_COMPONENTS

37: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
38: WHERE COMPONENT_ITEM_ID = l_comp_item_id
39: AND PARENT_BILL_SEQ_ID = l_bill_seq_id
40: AND 1 = (SELECT COUNT(*)
41: FROM BOM_INVENTORY_COMPONENTS
42: WHERE COMPONENT_ITEM_ID = l_comp_item_id
43: AND BILL_SEQUENCE_ID = l_bill_seq_id)
44: );
45: