DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_LINE_SCH_AVAIL_V

Line 3017: FROM mrp_line_sch_avail_v mls

3013: floor(mls.scheduled_completion_date-start_date)+client_start_date,--TZ BOM Calendar bug 3832684
3014: decode(x,1,sum(nvl(mls.planned_quantity,0)),
3015: 2,sum(nvl(mls.quantity_completed,0)),
3016: sum((nvl(mls.planned_quantity,0)-nvl(mls.quantity_completed,0))))
3017: FROM mrp_line_sch_avail_v mls
3018: WHERE mls.line_id = p_line_id
3019: AND mls.organization_id = p_org_id
3020: AND mls.scheduled_completion_date
3021: BETWEEN start_date and start_date+(7-1/(24*60*60))