VIEW: OKC.OKC_DELIVERABLES#

Source

View Text - Preformatted

select DELIVERABLE_ID DELIVERABLE_ID, BUSINESS_DOCUMENT_TYPE BUSINESS_DOCUMENT_TYPE, BUSINESS_DOCUMENT_ID BUSINESS_DOCUMENT_ID, BUSINESS_DOCUMENT_NUMBER BUSINESS_DOCUMENT_NUMBER, DELIVERABLE_TYPE DELIVERABLE_TYPE, RESPONSIBLE_PARTY RESPONSIBLE_PARTY, INTERNAL_PARTY_CONTACT_ID INTERNAL_PARTY_CONTACT_ID, EXTERNAL_PARTY_CONTACT_ID EXTERNAL_PARTY_CONTACT_ID, DELIVERABLE_NAME DELIVERABLE_NAME, DESCRIPTION DESCRIPTION, COMMENTS COMMENTS, DISPLAY_SEQUENCE DISPLAY_SEQUENCE, FIXED_DUE_DATE_YN FIXED_DUE_DATE_YN, ACTUAL_DUE_DATE ACTUAL_DUE_DATE, PRINT_DUE_DATE_MSG_NAME PRINT_DUE_DATE_MSG_NAME, RECURRING_YN RECURRING_YN, NOTIFY_PRIOR_DUE_DATE_VALUE NOTIFY_PRIOR_DUE_DATE_VALUE, NOTIFY_PRIOR_DUE_DATE_UOM NOTIFY_PRIOR_DUE_DATE_UOM, NOTIFY_PRIOR_DUE_DATE_YN NOTIFY_PRIOR_DUE_DATE_YN, NOTIFY_COMPLETED_YN NOTIFY_COMPLETED_YN, NOTIFY_OVERDUE_YN NOTIFY_OVERDUE_YN, NOTIFY_ESCALATION_YN NOTIFY_ESCALATION_YN, NOTIFY_ESCALATION_VALUE NOTIFY_ESCALATION_VALUE, NOTIFY_ESCALATION_UOM NOTIFY_ESCALATION_UOM, ESCALATION_ASSIGNEE ESCALATION_ASSIGNEE, AMENDMENT_OPERATION AMENDMENT_OPERATION, PRIOR_NOTIFICATION_ID PRIOR_NOTIFICATION_ID, AMENDMENT_NOTES AMENDMENT_NOTES, COMPLETED_NOTIFICATION_ID COMPLETED_NOTIFICATION_ID, OVERDUE_NOTIFICATION_ID OVERDUE_NOTIFICATION_ID, ESCALATION_NOTIFICATION_ID ESCALATION_NOTIFICATION_ID, LANGUAGE LANGUAGE, ORIGINAL_DELIVERABLE_ID ORIGINAL_DELIVERABLE_ID, REQUESTER_ID REQUESTER_ID, EXTERNAL_PARTY_ID EXTERNAL_PARTY_ID, RECURRING_DEL_PARENT_ID RECURRING_DEL_PARENT_ID, BUSINESS_DOCUMENT_VERSION BUSINESS_DOCUMENT_VERSION, RELATIVE_ST_DATE_DURATION RELATIVE_ST_DATE_DURATION, RELATIVE_ST_DATE_UOM RELATIVE_ST_DATE_UOM, RELATIVE_ST_DATE_EVENT_ID RELATIVE_ST_DATE_EVENT_ID, RELATIVE_END_DATE_DURATION RELATIVE_END_DATE_DURATION, RELATIVE_END_DATE_UOM RELATIVE_END_DATE_UOM, RELATIVE_END_DATE_EVENT_ID RELATIVE_END_DATE_EVENT_ID, REPEATING_DAY_OF_MONTH REPEATING_DAY_OF_MONTH, REPEATING_DAY_OF_WEEK REPEATING_DAY_OF_WEEK, REPEATING_FREQUENCY_UOM REPEATING_FREQUENCY_UOM, REPEATING_DURATION REPEATING_DURATION, FIXED_START_DATE FIXED_START_DATE, FIXED_END_DATE FIXED_END_DATE, MANAGE_YN MANAGE_YN, INTERNAL_PARTY_ID INTERNAL_PARTY_ID, DELIVERABLE_STATUS DELIVERABLE_STATUS, STATUS_CHANGE_NOTES STATUS_CHANGE_NOTES, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, DISABLE_NOTIFICATIONS_YN DISABLE_NOTIFICATIONS_YN, LAST_AMENDMENT_DATE LAST_AMENDMENT_DATE, BUSINESS_DOCUMENT_LINE_ID BUSINESS_DOCUMENT_LINE_ID, EXTERNAL_PARTY_SITE_ID EXTERNAL_PARTY_SITE_ID, START_EVENT_DATE START_EVENT_DATE, END_EVENT_DATE END_EVENT_DATE, SUMMARY_AMEND_OPERATION_CODE SUMMARY_AMEND_OPERATION_CODE, EXTERNAL_PARTY_ROLE EXTERNAL_PARTY_ROLE, PAY_HOLD_PRIOR_DUE_DATE_YN PAY_HOLD_PRIOR_DUE_DATE_YN, PAY_HOLD_PRIOR_DUE_DATE_VALUE PAY_HOLD_PRIOR_DUE_DATE_VALUE, PAY_HOLD_PRIOR_DUE_DATE_UOM PAY_HOLD_PRIOR_DUE_DATE_UOM, PAY_HOLD_OVERDUE_YN PAY_HOLD_OVERDUE_YN, COMPLETION_DATE COMPLETION_DATE, RAISE_COMPLETION_EVENT_YN RAISE_COMPLETION_EVENT_YN, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2, DEL_CATEGORY_CODE DEL_CATEGORY_CODE, EXHIBIT_CODE EXHIBIT_CODE, DATA_ITEM_NUMBER DATA_ITEM_NUMBER, PRICE_GROUP PRICE_GROUP, ESTIMATED_PRICE ESTIMATED_PRICE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, SCHEDULE_TYPE SCHEDULE_TYPE from "OKC"."OKC_DELIVERABLES"

View Text - HTML Formatted

SELECT DELIVERABLE_ID DELIVERABLE_ID
, BUSINESS_DOCUMENT_TYPE BUSINESS_DOCUMENT_TYPE
, BUSINESS_DOCUMENT_ID BUSINESS_DOCUMENT_ID
, BUSINESS_DOCUMENT_NUMBER BUSINESS_DOCUMENT_NUMBER
, DELIVERABLE_TYPE DELIVERABLE_TYPE
, RESPONSIBLE_PARTY RESPONSIBLE_PARTY
, INTERNAL_PARTY_CONTACT_ID INTERNAL_PARTY_CONTACT_ID
, EXTERNAL_PARTY_CONTACT_ID EXTERNAL_PARTY_CONTACT_ID
, DELIVERABLE_NAME DELIVERABLE_NAME
, DESCRIPTION DESCRIPTION
, COMMENTS COMMENTS
, DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, FIXED_DUE_DATE_YN FIXED_DUE_DATE_YN
, ACTUAL_DUE_DATE ACTUAL_DUE_DATE
, PRINT_DUE_DATE_MSG_NAME PRINT_DUE_DATE_MSG_NAME
, RECURRING_YN RECURRING_YN
, NOTIFY_PRIOR_DUE_DATE_VALUE NOTIFY_PRIOR_DUE_DATE_VALUE
, NOTIFY_PRIOR_DUE_DATE_UOM NOTIFY_PRIOR_DUE_DATE_UOM
, NOTIFY_PRIOR_DUE_DATE_YN NOTIFY_PRIOR_DUE_DATE_YN
, NOTIFY_COMPLETED_YN NOTIFY_COMPLETED_YN
, NOTIFY_OVERDUE_YN NOTIFY_OVERDUE_YN
, NOTIFY_ESCALATION_YN NOTIFY_ESCALATION_YN
, NOTIFY_ESCALATION_VALUE NOTIFY_ESCALATION_VALUE
, NOTIFY_ESCALATION_UOM NOTIFY_ESCALATION_UOM
, ESCALATION_ASSIGNEE ESCALATION_ASSIGNEE
, AMENDMENT_OPERATION AMENDMENT_OPERATION
, PRIOR_NOTIFICATION_ID PRIOR_NOTIFICATION_ID
, AMENDMENT_NOTES AMENDMENT_NOTES
, COMPLETED_NOTIFICATION_ID COMPLETED_NOTIFICATION_ID
, OVERDUE_NOTIFICATION_ID OVERDUE_NOTIFICATION_ID
, ESCALATION_NOTIFICATION_ID ESCALATION_NOTIFICATION_ID
, LANGUAGE LANGUAGE
, ORIGINAL_DELIVERABLE_ID ORIGINAL_DELIVERABLE_ID
, REQUESTER_ID REQUESTER_ID
, EXTERNAL_PARTY_ID EXTERNAL_PARTY_ID
, RECURRING_DEL_PARENT_ID RECURRING_DEL_PARENT_ID
, BUSINESS_DOCUMENT_VERSION BUSINESS_DOCUMENT_VERSION
, RELATIVE_ST_DATE_DURATION RELATIVE_ST_DATE_DURATION
, RELATIVE_ST_DATE_UOM RELATIVE_ST_DATE_UOM
, RELATIVE_ST_DATE_EVENT_ID RELATIVE_ST_DATE_EVENT_ID
, RELATIVE_END_DATE_DURATION RELATIVE_END_DATE_DURATION
, RELATIVE_END_DATE_UOM RELATIVE_END_DATE_UOM
, RELATIVE_END_DATE_EVENT_ID RELATIVE_END_DATE_EVENT_ID
, REPEATING_DAY_OF_MONTH REPEATING_DAY_OF_MONTH
, REPEATING_DAY_OF_WEEK REPEATING_DAY_OF_WEEK
, REPEATING_FREQUENCY_UOM REPEATING_FREQUENCY_UOM
, REPEATING_DURATION REPEATING_DURATION
, FIXED_START_DATE FIXED_START_DATE
, FIXED_END_DATE FIXED_END_DATE
, MANAGE_YN MANAGE_YN
, INTERNAL_PARTY_ID INTERNAL_PARTY_ID
, DELIVERABLE_STATUS DELIVERABLE_STATUS
, STATUS_CHANGE_NOTES STATUS_CHANGE_NOTES
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, DISABLE_NOTIFICATIONS_YN DISABLE_NOTIFICATIONS_YN
, LAST_AMENDMENT_DATE LAST_AMENDMENT_DATE
, BUSINESS_DOCUMENT_LINE_ID BUSINESS_DOCUMENT_LINE_ID
, EXTERNAL_PARTY_SITE_ID EXTERNAL_PARTY_SITE_ID
, START_EVENT_DATE START_EVENT_DATE
, END_EVENT_DATE END_EVENT_DATE
, SUMMARY_AMEND_OPERATION_CODE SUMMARY_AMEND_OPERATION_CODE
, EXTERNAL_PARTY_ROLE EXTERNAL_PARTY_ROLE
, PAY_HOLD_PRIOR_DUE_DATE_YN PAY_HOLD_PRIOR_DUE_DATE_YN
, PAY_HOLD_PRIOR_DUE_DATE_VALUE PAY_HOLD_PRIOR_DUE_DATE_VALUE
, PAY_HOLD_PRIOR_DUE_DATE_UOM PAY_HOLD_PRIOR_DUE_DATE_UOM
, PAY_HOLD_OVERDUE_YN PAY_HOLD_OVERDUE_YN
, COMPLETION_DATE COMPLETION_DATE
, RAISE_COMPLETION_EVENT_YN RAISE_COMPLETION_EVENT_YN
, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2
, DEL_CATEGORY_CODE DEL_CATEGORY_CODE
, EXHIBIT_CODE EXHIBIT_CODE
, DATA_ITEM_NUMBER DATA_ITEM_NUMBER
, PRICE_GROUP PRICE_GROUP
, ESTIMATED_PRICE ESTIMATED_PRICE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, SCHEDULE_TYPE SCHEDULE_TYPE
FROM "OKC"."OKC_DELIVERABLES"