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

VIEW: APPS.IEX_AGING_CNSLD_INV_DETAILS_V

Object Details
Object Name: IEX_AGING_CNSLD_INV_DETAILS_V
Object Type: VIEW
Owner: APPS
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
CONSOLIDATED_INVOICE_ID NUMBER
Yes Primary key column
PARTY_ID NUMBER (15) Yes
CUST_ACCOUNT_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER (15)
AGING_BUCKET_LINE_ID NUMBER (15) Yes
CONSOLIDATED_INVOICE_NUMBER VARCHAR2 (90)
CONSOLIDATED_INVOICE_AMOUNT NUMBER (14)
CONSOLIDATED_INVOICE_AMOUNT_CC VARCHAR2 (15) Yes
CONSOLIDATED_INVOICE_DUE_DATE DATE

DATE_CONSOLIDATED DATE
Yes
ORG_ID NUMBER (15)
OPERATING_UNIT VARCHAR2 (240) Yes
Query Text

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


SELECT CONSOLIDATED_INVOICE_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_SITE_USE_ID
,      AGING_BUCKET_LINE_ID
,      CONSOLIDATED_INVOICE_NUMBER
,      CONSOLIDATED_INVOICE_AMOUNT
,      CONSOLIDATED_INVOICE_AMOUNT_CC
,      CONSOLIDATED_INVOICE_DUE_DATE
,      DATE_CONSOLIDATED
,      ORG_ID
,      OPERATING_UNIT
FROM APPS.IEX_AGING_CNSLD_INV_DETAILS_V;

Dependencies

[top of page]

APPS.IEX_AGING_CNSLD_INV_DETAILS_V references the following:

SchemaAPPS
SynonymAR_AGING_BUCKET_LINES
SynonymAR_PAYMENT_SCHEDULES
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymOKL_CNSLD_AR_HDRS_B
SynonymOKL_CNSLD_AR_LINES_B
SynonymOKL_CNSLD_AR_STRMS_B
SynonymRA_CUSTOMER_TRX

APPS.IEX_AGING_CNSLD_INV_DETAILS_V is not referenced by any database object