DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_INVENTORY_COMPONENTS

Line 1222: FROM BOM_INVENTORY_COMPONENTS

1218: l_count1 NUMBER := 0;
1219: l_count2 NUMBER := NULL;
1220: CURSOR reschedule_valid IS
1221: SELECT 1
1222: FROM BOM_INVENTORY_COMPONENTS
1223: WHERE change_notice = p_revised_item_rec.eco_name
1224: AND bill_sequence_id = p_rev_item_unexp_rec.Bill_Sequence_Id
1225: AND revised_item_sequence_id =
1226: p_rev_item_unexp_rec.Revised_Item_Sequence_Id

Line 2230: FROM bom_inventory_components bic,

2226: , p_use_up_date DATE
2227: )
2228: IS
2229: SELECT component_sequence_id
2230: FROM bom_inventory_components bic,
2231: bom_bill_of_materials bom
2232: WHERE bic.component_item_id = p_use_up_item_id
2233: AND bic.implementation_date IS NOT NULL
2234: AND bic.bill_sequence_id = bom.bill_sequence_id

Line 5965: FROM BOM_INVENTORY_COMPONENTS

5961: l_allow_rev NUMBER := 0;
5962:
5963: CURSOR rev_comps IS
5964: SELECT 1
5965: FROM BOM_INVENTORY_COMPONENTS
5966: WHERE revised_item_sequence_id =
5967: p_rev_item_unexp_rec.revised_item_sequence_id;
5968:
5969: