View: CHV_SCHEDULE_HEADERS_ALL_V

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

View Text

SELECT CSH.SCHEDULE_NUM
, CSH.SCHEDULE_REVISION
, CSH.SCHEDULE_ID
, MTP.ORGANIZATION_CODE
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, CSH.SCHEDULE_HORIZON_START
, CSH.SCHEDULE_TYPE
, POL.DISPLAYED_FIELD SCHEDULE_TYPE_NAME
FROM CHV_SCHEDULE_HEADERS CSH
, 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.ORGANIZATION_ID = MTP.ORGANIZATION_ID(+)
AND CSH.VENDOR_ID = POV.VENDOR_ID
AND CSH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID

Columns