APPS.ENG_DEFAULT_REVISED_ITEM dependencies on BOM_LISTS

Line 1236: bom_lists bl

1232: l_inventory_use_up_date DATE := NULL;
1233: CURSOR SCHED_DATE IS
1234: SELECT si.inventory_use_up_date, bl.assembly_item_id
1235: FROM mrp_system_items si,
1236: bom_lists bl
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

Line 1272: l_sequence_id := ENG_REVISED_ITEMS_PKG.Get_BOM_Lists_Seq_Id;

1268: AND planned_organization = p_organization_id
1269: )
1270: );
1271: BEGIN
1272: l_sequence_id := ENG_REVISED_ITEMS_PKG.Get_BOM_Lists_Seq_Id;
1273:
1274: ENG_REVISED_ITEMS_PKG.Insert_BOM_Lists
1275: ( X_Revised_Item_Id => p_revised_item_id
1276: , X_Sequence_Id => l_sequence_id

Line 1274: ENG_REVISED_ITEMS_PKG.Insert_BOM_Lists

1270: );
1271: BEGIN
1272: l_sequence_id := ENG_REVISED_ITEMS_PKG.Get_BOM_Lists_Seq_Id;
1273:
1274: ENG_REVISED_ITEMS_PKG.Insert_BOM_Lists
1275: ( X_Revised_Item_Id => p_revised_item_id
1276: , X_Sequence_Id => l_sequence_id
1277: , X_Bill_Sequence_Id => p_bill_sequence_id
1278: );

Line 1287: ENG_REVISED_ITEMS_PKG.Delete_BOM_Lists (X_Sequence_Id => l_sequence_id);

1283: l_scheduled_date := l_sched_date.inventory_use_up_date;
1284: END IF;
1285: END LOOP;
1286:
1287: ENG_REVISED_ITEMS_PKG.Delete_BOM_Lists (X_Sequence_Id => l_sequence_id);
1288:
1289: RETURN l_scheduled_date;
1290:
1291: END Get_Scheduled_Date;