APPS.ENG_DEFAULT_REVISED_ITEM dependencies on BOM_INVENTORY_COMPONENTS

Line 1142: cursor bill_seq_id is select bom_inventory_components_s.nextval from sys.dual;

1138: FUNCTION Initialize_Bill_Sequence_Id
1139: RETURN NUMBER
1140: IS
1141: l_bill_sequence_id NUMBER;
1142: cursor bill_seq_id is select bom_inventory_components_s.nextval from sys.dual;
1143: BEGIN
1144: open bill_seq_id;
1145: fetch bill_seq_id into l_bill_sequence_id;
1146: close bill_seq_id;

Line 1241: FROM bom_inventory_components

1237: WHERE bl.sequence_id = l_sequence_id
1238: AND ( bl.assembly_item_id = p_revised_item_id
1239: OR bl.assembly_item_id IN
1240: ( SELECT component_item_id
1241: FROM bom_inventory_components
1242: WHERE bill_sequence_id = p_bill_sequence_id
1243: AND nvl(acd_type,1) <> 3
1244: AND effectivity_date <= si.inventory_use_up_date
1245: AND nvl(disable_date, si.inventory_use_up_date + 1) >