DBA Data[Home] [Help]

APPS.MSC_RESTORE_FIRM_PO dependencies on MSC_STORE_SUPPLIES

Line 248: FROM MSC_STORE_SUPPLIES

244: BEGIN
245: DELETE FROM MSC_SUPPLIES
246: WHERE (PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID) IN
247: (SELECT PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID
248: FROM MSC_STORE_SUPPLIES
249: WHERE plan_id = lv_plan_id)
250: AND plan_id = lv_plan_id;
251: LOG_MESSAGE('Deleted Supplies : ' || SQL%ROWCOUNT);
252:

Line 652: FROM MSC_STORE_SUPPLIES sup

648: ,sup.TOP_TRANSACTION_ID
649: ,sup.UNBUCKETED_NEW_SCHED_DATE
650: ,sup.IMPLEMENT_SHIP_METHOD
651: ,sup.ACTUAL_START_DATE
652: FROM MSC_STORE_SUPPLIES sup
653: WHERE sup.PLAN_ID = lv_plan_id;
654: LOG_MESSAGE('Inserted Supplies : ' || SQL%ROWCOUNT);
655:
656: EXCEPTION