APPS.OE_CONFIG dependencies on BOM_INVENTORY_COMPONENTS

Line 11: from bom_inventory_components bic

7: IS
8: CURSOR details(comp_common_bill_sequence_id NUMBER) IS
9:
10: select 'Y'
11: from bom_inventory_components bic
12: where bic.bill_sequence_id = comp_common_bill_sequence_id
13: and (bic.bom_item_type = 1
14: or bic.bom_item_type = 2
15: or (bic.optional = 1 and bic.bom_item_type = 4)

Line 30: from bom_inventory_components bic

26: where bom.assembly_item_id (+) = assembly_id
27: and bom.organization_id = org_id
28: and nvl(bom.alternate_bom_designator,'-99') = nvl(alt_desg,'-99')
29: and exists (select 'Exists'
30: from bom_inventory_components bic
31: where bic.bill_sequence_id = bom.common_bill_sequence_id
32: and optional = 1);*/
33:
34: details_flag VARCHAR2(15) := 'N';