VIEW: APPS.CHV_SCHEDULE_HEADERS_VAL_V

Source

View Text - Preformatted

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 , PVS.ORG_ID 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, PVS.ORG_ID

View Text - HTML Formatted

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
, PVS.ORG_ID
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
, PVS.ORG_ID