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

VIEW: APPS.OKS_BILLPRST_SRVLINE_V

Object Details
Object Name: OKS_BILLPRST_SRVLINE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_BILLPRST_SRVLINE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (150)
Type
NAME VARCHAR2 (240)
Name
DESCRIPTION VARCHAR2 (40)
Description
LINE_REFERENCE VARCHAR2 (300)
Line Reference
START_DATE DATE

Start Date
END_DATE DATE

End Date
EXTENDED_PRICE NUMBER

Extended Price
INVOICE_TEXT VARCHAR2 (2000)
Text of the Invoice.
DNZ_CHR_ID NUMBER
Yes Unique Identifier for Contract Header, denomalized for efficiency.
ID NUMBER
Yes Id
DATE_BILLED_FROM DATE
Yes Date Billed From
DATE_BILLED_TO DATE
Yes Date Billed To
AMOUNT_BILLED NUMBER (17)
Amount Billed
CLE_ID NUMBER

Unique Identifier for Contract Line.
BCL_ID NUMBER
Yes Bcl Id
CURRENCY_CODE VARCHAR2 (15)
Currency Code
BSL_ID NUMBER

Bsl Id
CONTRACT_NUMBER VARCHAR2 (241)
With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
Query Text

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


SELECT TYPE
,      NAME
,      DESCRIPTION
,      LINE_REFERENCE
,      START_DATE
,      END_DATE
,      EXTENDED_PRICE
,      INVOICE_TEXT
,      DNZ_CHR_ID
,      ID
,      DATE_BILLED_FROM
,      DATE_BILLED_TO
,      AMOUNT_BILLED
,      CLE_ID
,      BCL_ID
,      CURRENCY_CODE
,      BSL_ID
,      CONTRACT_NUMBER
FROM APPS.OKS_BILLPRST_SRVLINE_V;

Dependencies

[top of page]

APPS.OKS_BILLPRST_SRVLINE_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
ViewOKC_K_LINES_V
ViewOKC_LINE_STYLES_V
SynonymOKS_BILL_CONT_LINES
ViewOKS_K_LINES_V
ViewOKX_SYSTEM_ITEMS_V
APPS.OKS_BILLPRST_SRVLINE_V is referenced by following:

SchemaAPPS
Package BodyAR_LL_RCV_GROUPING_HOOK - show dependent code