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.CHV_SCHEDULE_HEADERS_ALL_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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