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

VIEW: APPS.IEX_TRANSACTIONS_V

Object Details
Object Name: IEX_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
TRX_NUMBER VARCHAR2 (20) Yes
TERMS_SEQUENCE_NUMBER NUMBER (15)
PURCHASE_ORDER VARCHAR2 (50)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
DUE_DATE DATE
Yes
TRX_DATE DATE
Yes
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
AMOUNT_DUE_ORIGINAL NUMBER
Yes
AMOUNT_DUE_REMAINING NUMBER
Yes
ACCTD_AMOUNT_DUE_REMAINING NUMBER
Yes
CUST_TRX_STATUS_CODE VARCHAR2 (30) Yes
CUST_TRX_STATUS_NAME VARCHAR2 (4000)
CUST_TRX_CLASS_CODE VARCHAR2 (20) Yes
CUST_TRX_CLASS_NAME VARCHAR2 (4000)
CUST_TRX_TYPE_ID NUMBER (15)
CUST_TRX_TYPE_NAME VARCHAR2 (20)
CUSTOMER_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER (15) Yes
CUSTOMER_TRX_ID NUMBER (15)
ORG_ID NUMBER (15)
CUSTOMER_NAME VARCHAR2 (50)
ACCOUNT_NUMBER VARCHAR2 (30) Yes
BILL_TO_LOCATION VARCHAR2 (40) Yes
BILL_TO_CONTACT_ID NUMBER (15)
DOC_SEQUENCE_VALUE NUMBER (15)
DELINQUENCY_ID NUMBER

DELINQUENCY_STATUS VARCHAR2 (30)
DEL_STATUS_DSP VARCHAR2 (4000)
DAYS_PAST_DUE NUMBER

DISPUTED_FLAG VARCHAR2 (1)
DISPUTE_DATE DATE

AMOUNT_IN_DISPUTE NUMBER

PROMISED_FLAG CHAR (0)
PAID_FLAG CHAR (0)
SALES_ORDER CHAR (0)
TRX_SCORE CHAR (0)
STRATEGY_NAME CHAR (0)
GL_DATE DATE
Yes
COMMENTS VARCHAR2 (1760)
TERM_ID NUMBER (15)
TERM_NAME VARCHAR2 (15)
PRIMARY_SALESREP_ID NUMBER (15)
PRIMARY_SALESREP_NAME VARCHAR2 (4000)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
INTERFACE_HEADER_CONTEXT VARCHAR2 (30)
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2 (150)
BILL_TO_ADDRESS_ID NUMBER (15)
BILL_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE21 VARCHAR2 (150)
GLOBAL_ATTRIBUTE22 VARCHAR2 (150)
GLOBAL_ATTRIBUTE23 VARCHAR2 (150)
GLOBAL_ATTRIBUTE24 VARCHAR2 (150)
GLOBAL_ATTRIBUTE25 VARCHAR2 (150)
GLOBAL_ATTRIBUTE26 VARCHAR2 (150)
GLOBAL_ATTRIBUTE27 VARCHAR2 (150)
GLOBAL_ATTRIBUTE28 VARCHAR2 (150)
GLOBAL_ATTRIBUTE29 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE30 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
SET_OF_BOOKS_ID NUMBER (15) Yes
PARTY_ID NUMBER (15) Yes
BILL_TO_ADDRESS VARCHAR2 (307)
PARTY_SITE_NUMBER VARCHAR2 (30) Yes
TRX_CREATION_DATE DATE
Yes
CONS_INV_ID NUMBER (15)
DEFAULT_PRINTING_OPTION VARCHAR2 (20)
CONS_BILLING_NUMBER VARCHAR2 (30)
OPERATING_UNIT VARCHAR2 (240)
UWQ_STATUS VARCHAR2 (4000)
UNPAID_REASON_MEANING VARCHAR2 (80)
RECEIVABLES_COMMENTS VARCHAR2 (1760)
RECEIVABLES_INTERNAL_NOTES VARCHAR2 (240)
RECEIVABLES_SPL_INSTRUCTIONS VARCHAR2 (240)
LEGAL_ENTITY_ID NUMBER (15)
LEGAL_ENTITY_NAME VARCHAR2 (240)
Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      TRX_NUMBER
,      TERMS_SEQUENCE_NUMBER
,      PURCHASE_ORDER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_DATE
,      TRX_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
,      CUST_TRX_TYPE_NAME
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      ORG_ID
,      CUSTOMER_NAME
,      ACCOUNT_NUMBER
,      BILL_TO_LOCATION
,      BILL_TO_CONTACT_ID
,      DOC_SEQUENCE_VALUE
,      DELINQUENCY_ID
,      DELINQUENCY_STATUS
,      DEL_STATUS_DSP
,      DAYS_PAST_DUE
,      DISPUTED_FLAG
,      DISPUTE_DATE
,      AMOUNT_IN_DISPUTE
,      PROMISED_FLAG
,      PAID_FLAG
,      SALES_ORDER
,      TRX_SCORE
,      STRATEGY_NAME
,      GL_DATE
,      COMMENTS
,      TERM_ID
,      TERM_NAME
,      PRIMARY_SALESREP_ID
,      PRIMARY_SALESREP_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      BILL_TO_ADDRESS_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE30
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      SET_OF_BOOKS_ID
,      PARTY_ID
,      BILL_TO_ADDRESS
,      PARTY_SITE_NUMBER
,      TRX_CREATION_DATE
,      CONS_INV_ID
,      DEFAULT_PRINTING_OPTION
,      CONS_BILLING_NUMBER
,      OPERATING_UNIT
,      UWQ_STATUS
,      UNPAID_REASON_MEANING
,      RECEIVABLES_COMMENTS
,      RECEIVABLES_INTERNAL_NOTES
,      RECEIVABLES_SPL_INSTRUCTIONS
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
FROM APPS.IEX_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.IEX_TRANSACTIONS_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
SynonymAR_CONS_INV
SynonymAR_PAYMENT_SCHEDULES
SynonymFND_LOOKUP_VALUES
ViewFND_TERRITORIES_VL
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymIEX_DELINQUENCIES
PL/SQL PackageIEX_UTILITIES - show dependent code
SynonymRA_CUSTOMER_TRX
SynonymRA_CUST_TRX_TYPES
ViewRA_TERMS_VL
SynonymXLE_ENTITY_PROFILES
APPS.IEX_TRANSACTIONS_V is referenced by following:

SchemaAPPS
ViewIEX_PAYING_DUNNINGS_BALI_V