VIEW: APPS.POS_PLAN_SCHEDULE_HEADERS_V

Source

View Text - Preformatted

SELECT CSH.ROWID , CSH.SCHEDULE_ID , CSH.VENDOR_ID , POV.VENDOR_NAME , POV.SEGMENT1 VENDOR_NUMBER, 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 TRUNC(SYSDATE) BETWEEN PRF.EFFECTIVE_START_DATE AND PRF.EFFECTIVE_END_DATE 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 (+) AND CSH.SCHEDULE_STATUS = 'CONFIRMED' AND CSH.SCHEDULE_TYPE = 'PLAN_SCHEDULE'

View Text - HTML Formatted

SELECT CSH.ROWID
, CSH.SCHEDULE_ID
, CSH.VENDOR_ID
, POV.VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, 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 TRUNC(SYSDATE) BETWEEN PRF.EFFECTIVE_START_DATE
AND PRF.EFFECTIVE_END_DATE
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 (+)
AND CSH.SCHEDULE_STATUS = 'CONFIRMED'
AND CSH.SCHEDULE_TYPE = 'PLAN_SCHEDULE'