VIEW: PO.CHV_SCHEDULE_HEADERS#

Source

View Text - Preformatted

select SCHEDULE_ID SCHEDULE_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, BATCH_ID BATCH_ID, SCHEDULE_TYPE SCHEDULE_TYPE, SCHEDULE_SUBTYPE SCHEDULE_SUBTYPE, SCHEDULE_HORIZON_START SCHEDULE_HORIZON_START, SCHEDULE_HORIZON_END SCHEDULE_HORIZON_END, BUCKET_PATTERN_ID BUCKET_PATTERN_ID, SCHEDULE_OWNER_ID SCHEDULE_OWNER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, SCHEDULE_NUM SCHEDULE_NUM, SCHEDULE_REVISION SCHEDULE_REVISION, ORGANIZATION_ID ORGANIZATION_ID, CONFIRM_DATE CONFIRM_DATE, MPS_SCHEDULE_DESIGNATOR MPS_SCHEDULE_DESIGNATOR, MRP_COMPILE_DESIGNATOR MRP_COMPILE_DESIGNATOR, DRP_COMPILE_DESIGNATOR DRP_COMPILE_DESIGNATOR, SCHEDULE_STATUS SCHEDULE_STATUS, INQUIRY_FLAG INQUIRY_FLAG, INCLUDE_FUTURE_RELEASES_FLAG INCLUDE_FUTURE_RELEASES_FLAG, COMMUNICATION_CODE COMMUNICATION_CODE, PRINT_COUNT PRINT_COUNT, LAST_PRINT_DATE LAST_PRINT_DATE, EDI_COUNT EDI_COUNT, LAST_EDI_DATE LAST_EDI_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS from "PO"."CHV_SCHEDULE_HEADERS"

View Text - HTML Formatted

SELECT SCHEDULE_ID SCHEDULE_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, BATCH_ID BATCH_ID
, SCHEDULE_TYPE SCHEDULE_TYPE
, SCHEDULE_SUBTYPE SCHEDULE_SUBTYPE
, SCHEDULE_HORIZON_START SCHEDULE_HORIZON_START
, SCHEDULE_HORIZON_END SCHEDULE_HORIZON_END
, BUCKET_PATTERN_ID BUCKET_PATTERN_ID
, SCHEDULE_OWNER_ID SCHEDULE_OWNER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, SCHEDULE_NUM SCHEDULE_NUM
, SCHEDULE_REVISION SCHEDULE_REVISION
, ORGANIZATION_ID ORGANIZATION_ID
, CONFIRM_DATE CONFIRM_DATE
, MPS_SCHEDULE_DESIGNATOR MPS_SCHEDULE_DESIGNATOR
, MRP_COMPILE_DESIGNATOR MRP_COMPILE_DESIGNATOR
, DRP_COMPILE_DESIGNATOR DRP_COMPILE_DESIGNATOR
, SCHEDULE_STATUS SCHEDULE_STATUS
, INQUIRY_FLAG INQUIRY_FLAG
, INCLUDE_FUTURE_RELEASES_FLAG INCLUDE_FUTURE_RELEASES_FLAG
, COMMUNICATION_CODE COMMUNICATION_CODE
, PRINT_COUNT PRINT_COUNT
, LAST_PRINT_DATE LAST_PRINT_DATE
, EDI_COUNT EDI_COUNT
, LAST_EDI_DATE LAST_EDI_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS
FROM "PO"."CHV_SCHEDULE_HEADERS"