View: CHV_SCHEDULE_HEADERS_VAL_V

Product:	CHV - Supplier Scheduling
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CHV_SCHEDULE_HEADERS_VAL_V

View Text

SELECT MAX(CONFIRM_DATE) CONFIRM_DATE
, MAX(CSH.SCHEDULE_REVISION) SCHEDULE_REVISION
, CSH.SCHEDULE_ID
, CSH.SCHEDULE_NUM
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, MTP.ORGANIZATION_CODE
, DECODE(CSH.ORGANIZATION_ID
, NULL
, 'Y'
, 'N')
, CSH.SCHEDULE_HORIZON_START
, CSH.SCHEDULE_TYPE
, POL.DISPLAYED_FIELD SCHEDULE_TYPE_NAME
FROM CHV_SCHEDULE_HEADERS CSH
, CHV_SCHEDULE_ITEMS CSI
, PO_LOOKUP_CODES POL
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, MTL_PARAMETERS MTP
WHERE CSH.SCHEDULE_TYPE = POL.LOOKUP_CODE
AND 'SCHEDULE_TYPE' = POL.LOOKUP_TYPE
AND CSH.VENDOR_ID = POV.VENDOR_ID
AND CSH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND CSI.ORGANIZATION_ID = MTP.ORGANIZATION_ID
AND CSI.SCHEDULE_ID = CSH.SCHEDULE_ID
AND CSH.SCHEDULE_STATUS = 'CONFIRMED' GROUP BY CSH.SCHEDULE_ID
, SCHEDULE_NUM
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, MTP.ORGANIZATION_CODE
, CSH.ORGANIZATION_ID
, CSH.SCHEDULE_HORIZON_START
, CSH.SCHEDULE_TYPE
, POL.DISPLAYED_FIELD

Columns