DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_INVENTORY_COMPONENTS

Line 1166: FROM BOM_INVENTORY_COMPONENTS

1162: l_count1 NUMBER := 0;
1163: l_count2 NUMBER := NULL;
1164: CURSOR reschedule_valid IS
1165: SELECT 1
1166: FROM BOM_INVENTORY_COMPONENTS
1167: WHERE change_notice = p_revised_item_rec.eco_name
1168: AND bill_sequence_id = p_rev_item_unexp_rec.Bill_Sequence_Id
1169: AND revised_item_sequence_id =
1170: p_rev_item_unexp_rec.Revised_Item_Sequence_Id

Line 2158: FROM bom_inventory_components bic,

2154: , p_use_up_date DATE
2155: )
2156: IS
2157: SELECT component_sequence_id
2158: FROM bom_inventory_components bic,
2159: bom_bill_of_materials bom
2160: WHERE bic.component_item_id = p_use_up_item_id
2161: AND bic.implementation_date IS NOT NULL
2162: AND bic.bill_sequence_id = bom.bill_sequence_id

Line 5884: FROM BOM_INVENTORY_COMPONENTS

5880: l_allow_rev NUMBER := 0;
5881:
5882: CURSOR rev_comps IS
5883: SELECT 1
5884: FROM BOM_INVENTORY_COMPONENTS
5885: WHERE revised_item_sequence_id =
5886: p_rev_item_unexp_rec.revised_item_sequence_id;
5887:
5888: