[Home] [Help] [Dependency Information]
Object Name: | OKC_DELIVERABLES# |
---|---|
Object Type: | VIEW |
Owner: | OKC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERABLE_ID | NUMBER | Yes | ||
BUSINESS_DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | |
BUSINESS_DOCUMENT_ID | NUMBER | Yes | ||
BUSINESS_DOCUMENT_NUMBER | VARCHAR2 | (150) | ||
DELIVERABLE_TYPE | VARCHAR2 | (30) | Yes | |
RESPONSIBLE_PARTY | VARCHAR2 | (30) | Yes | |
INTERNAL_PARTY_CONTACT_ID | NUMBER | |||
EXTERNAL_PARTY_CONTACT_ID | NUMBER | |||
DELIVERABLE_NAME | VARCHAR2 | (240) | Yes | |
DESCRIPTION | VARCHAR2 | (2000) | ||
COMMENTS | VARCHAR2 | (2000) | ||
DISPLAY_SEQUENCE | NUMBER | Yes | ||
FIXED_DUE_DATE_YN | VARCHAR2 | (1) | Yes | |
ACTUAL_DUE_DATE | DATE | |||
PRINT_DUE_DATE_MSG_NAME | VARCHAR2 | (30) | ||
RECURRING_YN | VARCHAR2 | (1) | Yes | |
NOTIFY_PRIOR_DUE_DATE_VALUE | NUMBER | |||
NOTIFY_PRIOR_DUE_DATE_UOM | VARCHAR2 | (30) | ||
NOTIFY_PRIOR_DUE_DATE_YN | VARCHAR2 | (1) | Yes | |
NOTIFY_COMPLETED_YN | VARCHAR2 | (1) | Yes | |
NOTIFY_OVERDUE_YN | VARCHAR2 | (1) | Yes | |
NOTIFY_ESCALATION_YN | VARCHAR2 | (1) | Yes | |
NOTIFY_ESCALATION_VALUE | NUMBER | |||
NOTIFY_ESCALATION_UOM | VARCHAR2 | (30) | ||
ESCALATION_ASSIGNEE | NUMBER | |||
AMENDMENT_OPERATION | VARCHAR2 | (30) | ||
PRIOR_NOTIFICATION_ID | NUMBER | |||
AMENDMENT_NOTES | VARCHAR2 | (2000) | ||
COMPLETED_NOTIFICATION_ID | NUMBER | |||
OVERDUE_NOTIFICATION_ID | NUMBER | |||
ESCALATION_NOTIFICATION_ID | NUMBER | |||
LANGUAGE | VARCHAR2 | (12) | Yes | |
ORIGINAL_DELIVERABLE_ID | NUMBER | Yes | ||
REQUESTER_ID | NUMBER | |||
EXTERNAL_PARTY_ID | NUMBER | |||
RECURRING_DEL_PARENT_ID | NUMBER | |||
BUSINESS_DOCUMENT_VERSION | NUMBER | Yes | ||
RELATIVE_ST_DATE_DURATION | NUMBER | |||
RELATIVE_ST_DATE_UOM | VARCHAR2 | (30) | ||
RELATIVE_ST_DATE_EVENT_ID | NUMBER | |||
RELATIVE_END_DATE_DURATION | NUMBER | |||
RELATIVE_END_DATE_UOM | VARCHAR2 | (30) | ||
RELATIVE_END_DATE_EVENT_ID | NUMBER | |||
REPEATING_DAY_OF_MONTH | VARCHAR2 | (30) | ||
REPEATING_DAY_OF_WEEK | VARCHAR2 | (30) | ||
REPEATING_FREQUENCY_UOM | VARCHAR2 | (30) | ||
REPEATING_DURATION | NUMBER | |||
FIXED_START_DATE | DATE | |||
FIXED_END_DATE | DATE | |||
MANAGE_YN | VARCHAR2 | (1) | Yes | |
INTERNAL_PARTY_ID | NUMBER | |||
DELIVERABLE_STATUS | VARCHAR2 | (30) | Yes | |
STATUS_CHANGE_NOTES | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
ATTRIBUTE1 | VARCHAR2 | (450) | ||
ATTRIBUTE2 | VARCHAR2 | (450) | ||
ATTRIBUTE3 | VARCHAR2 | (450) | ||
ATTRIBUTE4 | VARCHAR2 | (450) | ||
ATTRIBUTE5 | VARCHAR2 | (450) | ||
ATTRIBUTE6 | VARCHAR2 | (450) | ||
ATTRIBUTE7 | VARCHAR2 | (450) | ||
ATTRIBUTE8 | VARCHAR2 | (450) | ||
ATTRIBUTE9 | VARCHAR2 | (450) | ||
ATTRIBUTE10 | VARCHAR2 | (450) | ||
ATTRIBUTE11 | VARCHAR2 | (450) | ||
ATTRIBUTE12 | VARCHAR2 | (450) | ||
ATTRIBUTE13 | VARCHAR2 | (450) | ||
ATTRIBUTE14 | VARCHAR2 | (450) | ||
ATTRIBUTE15 | VARCHAR2 | (450) | ||
DISABLE_NOTIFICATIONS_YN | VARCHAR2 | (1) | Yes | |
LAST_AMENDMENT_DATE | DATE | |||
BUSINESS_DOCUMENT_LINE_ID | NUMBER | |||
EXTERNAL_PARTY_SITE_ID | NUMBER | |||
START_EVENT_DATE | DATE | |||
END_EVENT_DATE | DATE | |||
SUMMARY_AMEND_OPERATION_CODE | VARCHAR2 | (30) | ||
EXTERNAL_PARTY_ROLE | VARCHAR2 | (30) | ||
PAY_HOLD_PRIOR_DUE_DATE_YN | VARCHAR2 | (1) | ||
PAY_HOLD_PRIOR_DUE_DATE_VALUE | NUMBER | |||
PAY_HOLD_PRIOR_DUE_DATE_UOM | VARCHAR2 | (30) | ||
PAY_HOLD_OVERDUE_YN | VARCHAR2 | (1) | ||
COMPLETION_DATE | DATE | |||
RAISE_COMPLETION_EVENT_YN | VARCHAR2 | (1) | ||
ORIG_SYSTEM_REFERENCE_CODE | VARCHAR2 | (30) | ||
ORIG_SYSTEM_REFERENCE_ID1 | NUMBER | |||
ORIG_SYSTEM_REFERENCE_ID2 | NUMBER | |||
DEL_CATEGORY_CODE | VARCHAR2 | (30) | ||
EXHIBIT_CODE | VARCHAR2 | (30) | ||
DATA_ITEM_NUMBER | VARCHAR2 | (30) | ||
PRICE_GROUP | VARCHAR2 | (240) | ||
ESTIMATED_PRICE | NUMBER | |||
UDA_TEMPLATE_ID | NUMBER | |||
SCHEDULE_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERABLE_ID
, BUSINESS_DOCUMENT_TYPE
, BUSINESS_DOCUMENT_ID
, BUSINESS_DOCUMENT_NUMBER
, DELIVERABLE_TYPE
, RESPONSIBLE_PARTY
, INTERNAL_PARTY_CONTACT_ID
, EXTERNAL_PARTY_CONTACT_ID
, DELIVERABLE_NAME
, DESCRIPTION
, COMMENTS
, DISPLAY_SEQUENCE
, FIXED_DUE_DATE_YN
, ACTUAL_DUE_DATE
, PRINT_DUE_DATE_MSG_NAME
, RECURRING_YN
, NOTIFY_PRIOR_DUE_DATE_VALUE
, NOTIFY_PRIOR_DUE_DATE_UOM
, NOTIFY_PRIOR_DUE_DATE_YN
, NOTIFY_COMPLETED_YN
, NOTIFY_OVERDUE_YN
, NOTIFY_ESCALATION_YN
, NOTIFY_ESCALATION_VALUE
, NOTIFY_ESCALATION_UOM
, ESCALATION_ASSIGNEE
, AMENDMENT_OPERATION
, PRIOR_NOTIFICATION_ID
, AMENDMENT_NOTES
, COMPLETED_NOTIFICATION_ID
, OVERDUE_NOTIFICATION_ID
, ESCALATION_NOTIFICATION_ID
, LANGUAGE
, ORIGINAL_DELIVERABLE_ID
, REQUESTER_ID
, EXTERNAL_PARTY_ID
, RECURRING_DEL_PARENT_ID
, BUSINESS_DOCUMENT_VERSION
, RELATIVE_ST_DATE_DURATION
, RELATIVE_ST_DATE_UOM
, RELATIVE_ST_DATE_EVENT_ID
, RELATIVE_END_DATE_DURATION
, RELATIVE_END_DATE_UOM
, RELATIVE_END_DATE_EVENT_ID
, REPEATING_DAY_OF_MONTH
, REPEATING_DAY_OF_WEEK
, REPEATING_FREQUENCY_UOM
, REPEATING_DURATION
, FIXED_START_DATE
, FIXED_END_DATE
, MANAGE_YN
, INTERNAL_PARTY_ID
, DELIVERABLE_STATUS
, STATUS_CHANGE_NOTES
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DISABLE_NOTIFICATIONS_YN
, LAST_AMENDMENT_DATE
, BUSINESS_DOCUMENT_LINE_ID
, EXTERNAL_PARTY_SITE_ID
, START_EVENT_DATE
, END_EVENT_DATE
, SUMMARY_AMEND_OPERATION_CODE
, EXTERNAL_PARTY_ROLE
, PAY_HOLD_PRIOR_DUE_DATE_YN
, PAY_HOLD_PRIOR_DUE_DATE_VALUE
, PAY_HOLD_PRIOR_DUE_DATE_UOM
, PAY_HOLD_OVERDUE_YN
, COMPLETION_DATE
, RAISE_COMPLETION_EVENT_YN
, ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2
, DEL_CATEGORY_CODE
, EXHIBIT_CODE
, DATA_ITEM_NUMBER
, PRICE_GROUP
, ESTIMATED_PRICE
, UDA_TEMPLATE_ID
, SCHEDULE_TYPE
FROM OKC.OKC_DELIVERABLES#;
|
|
|