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

VIEW: APPS.OKE_DTS_SUBCONTRACTS_V

Object Details
Object Name: OKE_DTS_SUBCONTRACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_DTS_SUBCONTRACTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
K_HEADER_ID NUMBER
Yes Contract document unique identifier
K_LINE_ID NUMBER
Yes Contract document line item unique identifier
DELIVERABLE_ID NUMBER
Yes Contract deliverable unique identifier
SUBK_HEADER_ID NUMBER
Yes Subcontract header unique identifier
SUBK_LINE_ID NUMBER
Yes Subcontract line unique identifier
SUBK_DELIVERABLE_ID NUMBER
Yes Subcontract deliverable unique identifier
SUBCONTRACT_NUMBER VARCHAR2 (240)
Contract number of linked subcontract
SUBCONTRACT_LINE_NUMBER VARCHAR2 (150) Yes Contract line number of linked subcontract
SUBCONTRACT_DELIVERABLE_NUM VARCHAR2 (150) Yes Deliverable number of linked subcontract
SUBCONTRACT_K_TYPE VARCHAR2 (80) Yes Contract document type of linked subcontract
SUBCONTRACT_STATUS VARCHAR2 (90) Yes Status of linked subcontract
QUANTITY NUMBER

Subcontracted Quantity
DELIVERY_DATE DATE

Subcontract delivery date
NEED_BY_DATE DATE

Subcontract need by date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT K_HEADER_ID
,      K_LINE_ID
,      DELIVERABLE_ID
,      SUBK_HEADER_ID
,      SUBK_LINE_ID
,      SUBK_DELIVERABLE_ID
,      SUBCONTRACT_NUMBER
,      SUBCONTRACT_LINE_NUMBER
,      SUBCONTRACT_DELIVERABLE_NUM
,      SUBCONTRACT_K_TYPE
,      SUBCONTRACT_STATUS
,      QUANTITY
,      DELIVERY_DATE
,      NEED_BY_DATE
FROM APPS.OKE_DTS_SUBCONTRACTS_V;

Dependencies

[top of page]

APPS.OKE_DTS_SUBCONTRACTS_V references the following:

SchemaAPPS
ViewOKC_STATUSES_V
SynonymOKE_K_DELIVERABLES_B
ViewOKE_K_HEADERS_V
ViewOKE_K_LINES_V
ViewOKE_K_TYPES_VL

APPS.OKE_DTS_SUBCONTRACTS_V is not referenced by any database object