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

VIEW: APPS.OKL_BPD_CONTRACT_INVOICES_V

Object Details
Object Name: OKL_BPD_CONTRACT_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_CONTRACT_INVOICES_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
CONSOLIDATED_INVOICE_ID NUMBER

Consolidated Invoice Identifier.
CONSOLIDATED_INVOICE_NUMBER VARCHAR2 (90)
Consolidated Invoice Number.
RECEIVABLES_INVOICE_ID NUMBER

Receivables Invoice Identifier.
CONTRACT_ID NUMBER

Contract Identifier.
STREAM_TYPE_ID NUMBER

Stream Type Identifier.
REVENUE_REC_BASIS VARCHAR2 (30)
Revenue Rec Basis.
DUE_DATE DATE

Due Date.
CURRENCY_CODE VARCHAR2 (15)
Currency Code
AMOUNT_DUE_ORIGINAL NUMBER

Original Amount Due.
AMOUNT_DUE_REMAINING NUMBER

Remaining Amount Due.
STATUS VARCHAR2 (30)
Status
Query Text

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


SELECT CONSOLIDATED_INVOICE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      RECEIVABLES_INVOICE_ID
,      CONTRACT_ID
,      STREAM_TYPE_ID
,      REVENUE_REC_BASIS
,      DUE_DATE
,      CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      STATUS
FROM APPS.OKL_BPD_CONTRACT_INVOICES_V;

Dependencies

[top of page]

APPS.OKL_BPD_CONTRACT_INVOICES_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymOKC_K_HEADERS_ALL_B
PL/SQL PackageOKL_BILLING_UTIL_PVT - show dependent code
ViewOKL_BPD_AR_INV_LINES_V
SynonymOKL_CNSLD_AR_HDRS_B
SynonymOKL_CNSLD_AR_LINES_B
SynonymOKL_CNSLD_AR_STRMS_B
SynonymOKL_STRM_TYPE_B
APPS.OKL_BPD_CONTRACT_INVOICES_V is referenced by following:

SchemaAPPS
Package BodyOKL_LOSS_PROV_PVT - show dependent code