DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on MRP_SCHEDULE_CONSUMPTIONS

Line 224: FROM mrp_schedule_consumptions R

220: SCHEDULE_DATE = p_Demand_Date,
221: SCHEDULE_WORKDATE = p_workdate,
222: ORIGINAL_SCHEDULE_QUANTITY = p_Primary_Qty,
223: SCHEDULE_QUANTITY = ( SELECT greatest(p_Primary_Qty - nvl(sum(R.relief_quantity) , 0) , 0)
224: FROM mrp_schedule_consumptions R
225: WHERE R.transaction_id = d.mps_transaction_id ),
226: PROJECT_ID = p_Project_Id,
227: TASK_ID = p_Task_Id,
228: END_ITEM_UNIT_NUMBER = p_Unit_Number