DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_LINE_SCH_AVAIL_V

Line 3014: FROM mrp_line_sch_avail_v mls

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