Product: | POS - iSupplier Portal |
---|---|
Description: | used to select the schedule and vendor info |
Implementation/DBA Data: | APPS.POS_CHV_SCHEDULE_HEADERS_V |
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
, PLC1.DISPLAYED_FIELD
, CSH.SCHEDULE_SUBTYPE
, PLC2.DISPLAYED_FIELD
, 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
, PLC3.DISPLAYED_FIELD
, 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
, PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, PO_LOOKUP_CODES PLC3
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
AND CSH.SCHEDULE_TYPE = PLC1.LOOKUP_CODE (+)
AND ('SCHEDULE_TYPE') = PLC1.LOOKUP_TYPE (+)
AND CSH.SCHEDULE_SUBTYPE = PLC2.LOOKUP_CODE (+)
AND DECODE(CSH.SCHEDULE_TYPE
, 'SHIP_SCHEDULE'
, 'SHIP_SCHEDULE_SUBTYPE'
, 'PLAN_SCHEDULE'
, 'PLAN_SCHEDULE_SUBTYPE') = PLC2.LOOKUP_TYPE (+)
AND CSH.SCHEDULE_STATUS = PLC3.LOOKUP_CODE (+)
AND ('SCHEDULE_STATUS') = PLC3.LOOKUP_TYPE (+)