eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: OKC.OKC_DELIVERABLES#

Object Details

Object Name:	OKC_DELIVERABLES#
Object Type:	VIEW
Owner:	OKC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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#;

Dependencies

[top of page]

OKC.OKC_DELIVERABLES# references the following:

OKC: OKC_DELIVERABLES

OKC.OKC_DELIVERABLES# is referenced by following:

APPS: OKC_DELIVERABLES; OKC_DELIVERABLES_SEC