DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on MRP_SCHEDULE_CONSUMPTIONS

Line 327: from mrp_schedule_consumptions ref

323: SCHEDULE_DESIGNATOR = cinfo.Schedule_Designator,
324: SCHEDULE_DATE = cinfo.Expected_Date,
325: SCHEDULE_WORKDATE = cinfo.Workdate,
326: SCHEDULE_QUANTITY = ( select greatest(L_Primary_Qty - nvl(sum(ref.relief_quantity) , 0) , 0)
327: from mrp_schedule_consumptions ref
328: where ref.transaction_id = x_mps_transaction_id ),
329: PROJECT_ID = cinfo.Project_Id,
330: TASK_ID = cinfo.Task_Id,
331: END_ITEM_UNIT_NUMBER = cinfo.Unit_Number