View: POS_CHV_SCHEDULE_HEADERS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_CHV_SCHEDULE_HEADERS_V

View Text

SELECT CSH.ROWID
, CSH.SCHEDULE_ID
, CSH.VENDOR_ID
, POV.VENDOR_NAME
, POV.HOLD_FLAG
, CSH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, CSH.BATCH_ID
, CSH.SCHEDULE_TYPE
, NULL
, CSH.SCHEDULE_SUBTYPE
, NULL
, CSH.SCHEDULE_NUM
, CSH.SCHEDULE_REVISION
, CSH.SCHEDULE_HORIZON_START
, CSH.SCHEDULE_HORIZON_END
, CSH.SCHEDULE_OWNER_ID
, PRF.FULL_NAME
, CSH.BUCKET_PATTERN_ID
, CBP.BUCKET_PATTERN_NAME
, CBP.DESCRIPTION
, CSH.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, CSH.CONFIRM_DATE
, CSH.PRINT_COUNT
, CSH.LAST_PRINT_DATE
, CSH.EDI_COUNT
, CSH.LAST_EDI_DATE
, CSH.MPS_SCHEDULE_DESIGNATOR
, CSH.MRP_COMPILE_DESIGNATOR
, CSH.DRP_COMPILE_DESIGNATOR
, CSH.SCHEDULE_STATUS
, NULL
, CSH.INQUIRY_FLAG
, CSH.INCLUDE_FUTURE_RELEASES_FLAG
, CSH.ATTRIBUTE_CATEGORY
, CSH.ATTRIBUTE1
, CSH.ATTRIBUTE2
, CSH.ATTRIBUTE3
, CSH.ATTRIBUTE4
, CSH.ATTRIBUTE5
, CSH.ATTRIBUTE6
, CSH.ATTRIBUTE7
, CSH.ATTRIBUTE8
, CSH.ATTRIBUTE9
, CSH.ATTRIBUTE10
, CSH.ATTRIBUTE11
, CSH.ATTRIBUTE12
, CSH.ATTRIBUTE13
, CSH.ATTRIBUTE14
, CSH.ATTRIBUTE15
, CSH.LAST_UPDATE_DATE
, CSH.LAST_UPDATED_BY
, CSH.CREATION_DATE
, CSH.CREATED_BY
, CSH.LAST_UPDATE_LOGIN
, CSH.REQUEST_ID
, CSH.PROGRAM_APPLICATION_ID
, CSH.PROGRAM_ID
, CSH.PROGRAM_UPDATE_DATE
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, CHV_SCHEDULE_HEADERS CSH
, ORG_ORGANIZATION_DEFINITIONS ORG
, CHV_BUCKET_PATTERNS CBP
, PER_ALL_PEOPLE_F PRF
WHERE CSH.VENDOR_ID = POV.VENDOR_ID
AND CSH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND CSH.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND CSH.BUCKET_PATTERN_ID = CBP.BUCKET_PATTERN_ID
AND CSH.SCHEDULE_OWNER_ID = PRF.PERSON_ID(+)

Columns