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

VIEW: APPS.OKS_INV_RVW_V

Object Details
Object Name: OKS_INV_RVW_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_INV_RVW_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
BCL_ID NUMBER

Id of the Line from OKS_BILL_CONT_LINES
INVOICE_NUMBER VARCHAR2 (60)
Invoice Number
INVOICE_CLASS VARCHAR2 (60)
Invoice Class
TRANSACTION_TYPE VARCHAR2 (80)
Transaction Type
BCL_CLE_ID NUMBER

ID of the Top Line in OKS_BILL_CONT_LINES
BSL_CLE_ID NUMBER

Id of the subline in OKS_BILL_SUB_LINES
BTN_ID NUMBER

Id of the line in OKS_BILL_TRANSACTIONS
BTL_ID NUMBER

Id of the line in bill_txn_lines
BILL_INSTANCE_NUMBER NUMBER (30)
bill_instance_number from oks_bill_txn_lines
INVOICE_DATE DATE

Invoice Date
BCL_BILL_FROM_DATE DATE

Bill_cont_lines bill from date
BCL_BILL_TO_DATE DATE

bill to date from oks_bill_cont_lines table
BSL_BILL_FROM_DATE DATE

bill_from_date from oks_bill_sub_lines table
BSL_BILL_TO_DATE DATE

Bill to date from oks_bill_sub_lines table
CURRENCY_CODE VARCHAR2 (15)
Currency Code
Query Text

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


SELECT BCL_ID
,      INVOICE_NUMBER
,      INVOICE_CLASS
,      TRANSACTION_TYPE
,      BCL_CLE_ID
,      BSL_CLE_ID
,      BTN_ID
,      BTL_ID
,      BILL_INSTANCE_NUMBER
,      INVOICE_DATE
,      BCL_BILL_FROM_DATE
,      BCL_BILL_TO_DATE
,      BSL_BILL_FROM_DATE
,      BSL_BILL_TO_DATE
,      CURRENCY_CODE
FROM APPS.OKS_INV_RVW_V;

Dependencies

[top of page]

APPS.OKS_INV_RVW_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKS_BILL_CONT_LINES
SynonymOKS_BILL_SUB_LINES
SynonymOKS_BILL_TRANSACTIONS
SynonymOKS_BILL_TXN_LINES

APPS.OKS_INV_RVW_V is not referenced by any database object