eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_FLOW_LINE_LINEARITY_V

Source

View Text - Preformatted


SELECT bcd2.calendar_date, nvl(inner_query.planned_quantity,0) planned_quantity, nvl(inner_query.quantity_completed,0) quantity_completed from bom_calendar_dates bcd2, ( select bcd.calendar_date calendar_date, nvl(sum(wfs.planned_quantity),0) planned_quantity, nvl(sum(wfs.quantity_completed),0) quantity_completed from wip_flow_schedules wfs, bom_calendar_dates bcd, mtl_parameters mp where mp.organization_id = wip_sfcb_utilities.get_organization and bcd.exception_set_id = mp.calendar_exception_set_id and bcd.calendar_code = mp.calendar_code and bcd.calendar_date between wip_sfcb_utilities.sdate_to_cdate(wip_sfcb_utilities.get_linearity_from_date) and wip_sfcb_utilities.sdate_to_cdate(wip_sfcb_utilities.get_linearity_to_date) and wfs.scheduled_completion_date >= wip_sfcb_utilities.get_linearity_from_date and wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date) < bcd.calendar_date + 1 and wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date) >= bcd.calendar_date and wfs.line_id = wip_sfcb_utilities.get_line group by bcd.calendar_date ) inner_query, mtl_parameters mp where mp.organization_id = wip_sfcb_utilities.get_organization and bcd2.exception_set_id = mp.calendar_exception_set_id and bcd2.calendar_code = mp.calendar_code and bcd2.calendar_date between wip_sfcb_utilities.sdate_to_cdate(wip_sfcb_utilities.get_linearity_from_date) and wip_sfcb_utilities.sdate_to_cdate(wip_sfcb_utilities.get_linearity_to_date) and bcd2.calendar_date = inner_query.calendar_date (+)

View Text - HTML Formatted

SELECT BCD2.CALENDAR_DATE
, NVL(INNER_QUERY.PLANNED_QUANTITY
, 0) PLANNED_QUANTITY
, NVL(INNER_QUERY.QUANTITY_COMPLETED
, 0) QUANTITY_COMPLETED
FROM BOM_CALENDAR_DATES BCD2
, ( SELECT BCD.CALENDAR_DATE CALENDAR_DATE
, NVL(SUM(WFS.PLANNED_QUANTITY)
, 0) PLANNED_QUANTITY
, NVL(SUM(WFS.QUANTITY_COMPLETED)
, 0) QUANTITY_COMPLETED
FROM WIP_FLOW_SCHEDULES WFS
, BOM_CALENDAR_DATES BCD
, MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = WIP_SFCB_UTILITIES.GET_ORGANIZATION
AND BCD.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
AND BCD.CALENDAR_CODE = MP.CALENDAR_CODE
AND BCD.CALENDAR_DATE BETWEEN WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WIP_SFCB_UTILITIES.GET_LINEARITY_FROM_DATE)
AND WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WIP_SFCB_UTILITIES.GET_LINEARITY_TO_DATE)
AND WFS.SCHEDULED_COMPLETION_DATE >= WIP_SFCB_UTILITIES.GET_LINEARITY_FROM_DATE
AND WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WFS.SCHEDULED_COMPLETION_DATE) < BCD.CALENDAR_DATE + 1
AND WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WFS.SCHEDULED_COMPLETION_DATE) >= BCD.CALENDAR_DATE
AND WFS.LINE_ID = WIP_SFCB_UTILITIES.GET_LINE GROUP BY BCD.CALENDAR_DATE ) INNER_QUERY
, MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = WIP_SFCB_UTILITIES.GET_ORGANIZATION
AND BCD2.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
AND BCD2.CALENDAR_DATE BETWEEN WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WIP_SFCB_UTILITIES.GET_LINEARITY_FROM_DATE)
AND WIP_SFCB_UTILITIES.SDATE_TO_CDATE(WIP_SFCB_UTILITIES.GET_LINEARITY_TO_DATE)
AND BCD2.CALENDAR_DATE = INNER_QUERY.CALENDAR_DATE (+)