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


VIEW: APPS.IEX_AG_TRX_V

Object Details
Object Name: IEX_AG_TRX_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)
TRX_NUMBER VARCHAR2 (30)
TERMS_SEQUENCE_NUMBER NUMBER (15)
PURCHASE_ORDER VARCHAR2 (50)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
DUE_DATE DATE

TRX_DATE DATE

INVOICE_CURRENCY_CODE VARCHAR2 (15)
AMOUNT_DUE_ORIGINAL NUMBER

AMOUNT_DUE_REMAINING NUMBER

ACCTD_AMOUNT_DUE_REMAINING NUMBER

CUST_TRX_STATUS_CODE VARCHAR2 (30)
CUST_TRX_STATUS_NAME VARCHAR2 (4000)
CUST_TRX_CLASS_CODE VARCHAR2 (20)
CUST_TRX_CLASS_NAME VARCHAR2 (4000)
CUST_TRX_TYPE_ID NUMBER (15)
CUST_TRX_TYPE_NAME VARCHAR2 (30)
CUSTOMER_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER

CUSTOMER_TRX_ID NUMBER (15)
ORG_ID NUMBER (15)
CUSTOMER_NAME VARCHAR2 (50)
ACCOUNT_NUMBER VARCHAR2 (30)
BILL_TO_LOCATION VARCHAR2 (40)
BILL_TO_CONTACT_ID NUMBER

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

COMMENTS VARCHAR2 (2000)
TERM_ID NUMBER (15)
TERM_NAME VARCHAR2 (4000)
PRIMARY_SALESREP_ID NUMBER

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

BILL_TO_CUSTOMER_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

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)
PARTY_ID NUMBER (15)
BILL_TO_ADDRESS VARCHAR2 (307)
PARTY_SITE_NUMBER VARCHAR2 (30)
TRX_CREATION_DATE DATE

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 (4000)
RECEIVABLES_COMMENTS VARCHAR2 (2000)
RECEIVABLES_INTERNAL_NOTES VARCHAR2 (240)
RECEIVABLES_SPL_INSTRUCTIONS VARCHAR2 (240)
LEGAL_ENTITY_ID NUMBER

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_AG_TRX_V;

Dependencies

[top of page]

APPS.IEX_AG_TRX_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
PL/SQL PackageARP_VIEW_CONSTANTS - show dependent code
SynonymAR_CASH_RECEIPTS
SynonymAR_CASH_RECEIPT_HISTORY
SynonymAR_CONS_INV
ViewAR_LOOKUPS
SynonymAR_PAYMENT_SCHEDULES
SynonymAR_RECEIPT_METHODS
SynonymFND_CURRENCIES
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
SynonymXLE_ENTITY_PROFILES

APPS.IEX_AG_TRX_V is not referenced by any database object