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

VIEW: APPS.IEX_DEL_CONTRACTS_NEW_V

Object Details
Object Name: IEX_DEL_CONTRACTS_NEW_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
CONTRACT_ID VARCHAR2 (150)
Interface header attribute value
CONTRACT_NUMBER VARCHAR2 (150)
Interface header attribute value
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies the payment schedule
CUSTOMER_TRX_ID NUMBER (15)
Identifies the item itself
PARTY_ID NUMBER (15) Yes A foreign key to the HZ_PARTY table.
CUST_ACCOUNT_ID NUMBER (15) Yes Customer account identifier
CLASS VARCHAR2 (20) Yes Lookup code for the class of the payment schedule
STATUS VARCHAR2 (30) Yes Lookup code for the status of the item
AMOUNT_DUE_ORIGINAL NUMBER
Yes The original amount due
AMOUNT_DUE_REMAINING NUMBER
Yes The current amount due remaining
TRX_DATE DATE

The transaction date of the item
GL_DATE DATE
Yes General Ledger date
DUE_DATE DATE
Yes Due date of this installment
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      CLASS
,      STATUS
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      TRX_DATE
,      GL_DATE
,      DUE_DATE
FROM APPS.IEX_DEL_CONTRACTS_NEW_V;

Dependencies

[top of page]

APPS.IEX_DEL_CONTRACTS_NEW_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymHZ_CUST_ACCOUNTS
SynonymRA_CUSTOMER_TRX_ALL

APPS.IEX_DEL_CONTRACTS_NEW_V is not referenced by any database object