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

VIEW: APPS.OKL_BPD_CNSLD_INV_REMAINING_V

Object Details
Object Name: OKL_BPD_CNSLD_INV_REMAINING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_CNSLD_INV_REMAINING_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
Yes
CONSOLIDATED_INVOICE_NUMBER VARCHAR2 (90)
CONSOLIDATED_DATE DATE
Yes
CUSTOMER_ID NUMBER
Yes
CUSTOMER_NAME VARCHAR2 (360) Yes
CUSTOMER_NUMBER VARCHAR2 (30) Yes
CUSTOMER_SITE_USE_ID NUMBER (15)
customer site use id
CURRENCY_CODE VARCHAR2 (15) Yes
AMOUNT NUMBER

Amount
Query Text

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


SELECT CONSOLIDATED_INVOICE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      CONSOLIDATED_DATE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE_ID
,      CURRENCY_CODE
,      AMOUNT
FROM APPS.OKL_BPD_CNSLD_INV_REMAINING_V;

Dependencies

[top of page]

APPS.OKL_BPD_CNSLD_INV_REMAINING_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymOKL_CNSLD_AR_HDRS_B
SynonymOKL_CNSLD_AR_LINES_B
SynonymOKL_CNSLD_AR_STRMS_B
SynonymOKL_STRM_TYPE_B

APPS.OKL_BPD_CNSLD_INV_REMAINING_V is not referenced by any database object