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


VIEW: APPS.IEX_DUNNING_TRANSACTIONS_V

Object Details
Object Name: IEX_DUNNING_TRANSACTIONS_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
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies the delinquent payment schedule
TRX_NUMBER VARCHAR2 (30)
The transaction number of the item.
CASH_RECEIPT_ID NUMBER (15)
Identifies the payment (cash receipt)
TERMS_SEQUENCE_NUMBER NUMBER (15)
The sequence number given to each installment for multiple payment terms
DUE_DATE DATE
Yes Due date of this installment
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes Lookup code for the currency of the invoice
AMOUNT_DUE_ORIGINAL NUMBER
Yes The original amount due
AMOUNT_DUE_REMAINING NUMBER
Yes The current amount due remaining
ACCTD_AMOUNT_DUE_REMAINING NUMBER
Yes Open amount of transaction in functional currency
CUST_TRX_STATUS_CODE VARCHAR2 (30) Yes Lookup code for the status of the item
CUST_TRX_STATUS_NAME VARCHAR2 (4000)
Lookup code for the class of the payment schedule
CUST_TRX_CLASS_CODE VARCHAR2 (20) Yes Lookup code for the status of the item
CUST_TRX_CLASS_NAME VARCHAR2 (4000)
Lookup code for the class of the payment schedule
CUST_TRX_TYPE_ID NUMBER (15)
Identifies the transaction type of the item
CUSTOMER_ID NUMBER (15)
Identifies the customer associated with the item
CUSTOMER_SITE_USE_ID NUMBER (15) Yes Identifies the customer site associated with the customer. This must be a 'BILL_TO' site.
CUSTOMER_TRX_ID NUMBER (15)
Identifier of the customer trx id associated with this dunned record
ORG_ID NUMBER (15)
Organization identifier
CUSTOMER_NAME VARCHAR2 (50)
Name of this party
ACCOUNT_NUMBER VARCHAR2 (30) Yes Account Number
BILL_TO_LOCATION VARCHAR2 (40) Yes Name of Bill to Location
DELINQUENCY_ID NUMBER

Identifier for Delinquency.
DELINQUENCY_STATUS VARCHAR2 (30)
Delinquency Status Code
DEL_STATUS_DSP VARCHAR2 (4000)
Delinquency Status meaning
DAYS_PAST_DUE NUMBER

Number of days past due.
DISPUTED_FLAG VARCHAR2 (1)
Dispute or not.
DISPUTE_DATE DATE

Disputed Date.
AMOUNT_IN_DISPUTE NUMBER

Amount Disputed
GL_DATE DATE
Yes General Ledger date
PARTY_ID NUMBER (15) Yes Party identifier
PARTY_SITE_NUMBER VARCHAR2 (30) Yes Party site number
CONS_INV_ID NUMBER (15)
Consolidated invoice ID that contains this transaction
OPERATING_UNIT VARCHAR2 (240)
Operating Unit name.
UWQ_STATUS VARCHAR2 (4000)
Status in UWQ
UNPAID_REASON_MEANING VARCHAR2 (4000)
Unpaid Reason
STAGED_DUNNING_LEVEL NUMBER

Dunning level of the item as printed on the dunning correspondence
DUNNING_TRX_ID NUMBER
Yes Primary key in IEX_DINNING_TRANSACTIONS table
DUNNING_ID NUMBER

Foreign key to IEX_DUNNINGS table
Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      TRX_NUMBER
,      CASH_RECEIPT_ID
,      TERMS_SEQUENCE_NUMBER
,      DUE_DATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_DUE_REMAINING
,      CUST_TRX_STATUS_CODE
,      CUST_TRX_STATUS_NAME
,      CUST_TRX_CLASS_CODE
,      CUST_TRX_CLASS_NAME
,      CUST_TRX_TYPE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      ORG_ID
,      CUSTOMER_NAME
,      ACCOUNT_NUMBER
,      BILL_TO_LOCATION
,      DELINQUENCY_ID
,      DELINQUENCY_STATUS
,      DEL_STATUS_DSP
,      DAYS_PAST_DUE
,      DISPUTED_FLAG
,      DISPUTE_DATE
,      AMOUNT_IN_DISPUTE
,      GL_DATE
,      PARTY_ID
,      PARTY_SITE_NUMBER
,      CONS_INV_ID
,      OPERATING_UNIT
,      UWQ_STATUS
,      UNPAID_REASON_MEANING
,      STAGED_DUNNING_LEVEL
,      DUNNING_TRX_ID
,      DUNNING_ID
FROM APPS.IEX_DUNNING_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.IEX_DUNNING_TRANSACTIONS_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
SynonymAR_PAYMENT_SCHEDULES
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymIEX_DELINQUENCIES
SynonymIEX_DUNNING_TRANSACTIONS
PL/SQL PackageIEX_UTILITIES - show dependent code

APPS.IEX_DUNNING_TRANSACTIONS_V is not referenced by any database object