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


VIEW: APPS.OKL_LA_LINK_SERVICE_UV

Object Details
Object Name: OKL_LA_LINK_SERVICE_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_LINK_SERVICE_UV
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
CHR_ID NUMBER
Yes Contract identifier
CONTRACT_NUMBER VARCHAR2 (120) Yes Service contract number
SHORT_DESCRIPTION VARCHAR2 (600)
Service contract short description
CURRENCY_CODE VARCHAR2 (15)
Currency code
AUTHORING_ORG_ID NUMBER
Yes Operating unit identifier
INV_ORGANIZATION_ID NUMBER
Yes Inventory organization identifier
CUSTOMER_ID NUMBER (15) Yes Customer account identifier
CUSTOMER_NUMBER VARCHAR2 (30) Yes Customer number
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CLE_ID NUMBER
Yes Contract line identifier
LTY_CODE VARCHAR2 (30) Yes contract line type code
ITEM_NAME VARCHAR2 (40)
Contract line item name
ITEM_DESCRIPTION VARCHAR2 (240)
Contract line item description
ITEM_ID VARCHAR2 (40)
Contract line item identifier
START_DATE DATE

Start date
END_DATE DATE

End date
BILL_TO_ID NUMBER (15)
Bill to site use identifier
COVERED_ITEM_ID NUMBER
Yes Covered item identifier
COVERED_ITEM_NAME VARCHAR2 (40)
Covered item name
COVERED_ITEM_DESCRIPTION VARCHAR2 (240)
Covered item description
Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      SHORT_DESCRIPTION
,      CURRENCY_CODE
,      AUTHORING_ORG_ID
,      INV_ORGANIZATION_ID
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      CLE_ID
,      LTY_CODE
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      ITEM_ID
,      START_DATE
,      END_DATE
,      BILL_TO_ID
,      COVERED_ITEM_ID
,      COVERED_ITEM_NAME
,      COVERED_ITEM_DESCRIPTION
FROM APPS.OKL_LA_LINK_SERVICE_UV;

Dependencies

[top of page]

APPS.OKL_LA_LINK_SERVICE_UV references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymHZ_PARTIES
SynonymMTL_SYSTEM_ITEMS_B
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_K_PARTY_ROLES_B
SynonymOKC_LINE_STYLES_B
APPS.OKL_LA_LINK_SERVICE_UV is referenced by following:

SchemaAPPS
Package BodyOKL_CONTRACT_TOP_LINE_PVT - show dependent code
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code