View: WIP_FLOW_LINE_LINEARITY_V

Product:	WIP - Work in Process
Description:	Flow Workstation base view
Implementation/DBA Data:	APPS.WIP_FLOW_LINE_LINEARITY_V

View Text

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 (+)

Columns