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

VIEW: APPS.IEX_LS_TRX_ADV_V

Object Details
Object Name: IEX_LS_TRX_ADV_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 payment schedule
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
TERMS_SEQUENCE_NUMBER NUMBER (15)
The sequence number given to each installment for multiple payment terms
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DUE_DATE DATE
Yes Due date of this installment
TRX_DATE DATE
Yes Invoice date
DAYS_PAST_DUE NUMBER

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 (80) Yes
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
CUST_TRX_CLASS_CODE VARCHAR2 (20) Yes
CUST_TRX_CLASS_NAME VARCHAR2 (80) Yes
CUST_TRX_TYPE_ID NUMBER (15)
CUST_TRX_TYPE_NAME VARCHAR2 (20)
PARTY_ID NUMBER (15) Yes
CUSTOMER_ID NUMBER (15)
CUSTOMER_SITE_USE_ID NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

ORG_ID NUMBER (15)
Organization identifier
CUSTOMER_NAME VARCHAR2 (360) Yes
ACCOUNT_NUMBER VARCHAR2 (30) Yes
LOCATION VARCHAR2 (40) Yes
BILL_TO_CONTACT_ID NUMBER (15)
BILL_TO_FIRST_NAME VARCHAR2 (150)
BILL_TO_LAST_NAME VARCHAR2 (150)
PARTY_SITE_ID NUMBER (15) Yes
LOCATION_ID NUMBER (15) Yes
BILL_TO_ADDRESS1 VARCHAR2 (240) Yes
BILL_TO_ADDRESS2 VARCHAR2 (240)
BILL_TO_ADDRESS3 VARCHAR2 (240)
BILL_TO_ADDRESS4 VARCHAR2 (240)
BILL_TO_CITY VARCHAR2 (60)
BILL_TO_COUNTY VARCHAR2 (60)
BILL_TO_STATE VARCHAR2 (60)
BILL_TO_PROVINCE VARCHAR2 (60)
BILL_TO_POSTAL_CODE VARCHAR2 (60)
BILL_TO_COUNTRY_CODE VARCHAR2 (60) Yes
BILL_TO_COUNTRY VARCHAR2 (80)
BILL_TO_EMAIL_ADDRESS VARCHAR2 (2000)
BILL_TO_PHONE_NUMBER VARCHAR2 (40)
BILL_TO_PHONE_AREA_CODE VARCHAR2 (10)
BILL_TO_PHONE_COUNTRY_CODE VARCHAR2 (10)
BILL_TO_PHONE_TYPE_CODE VARCHAR2 (30)
BILL_TO_PHONE_TYPE_NAME VARCHAR2 (80)
DOC_SEQUENCE_VALUE NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
BILL_TO_PHONE_EXTENSION VARCHAR2 (20)
BILL_TO_FULL_PHONE_NUMBER VARCHAR2 (83)
PURCHASE_ORDER VARCHAR2 (50)
Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      TRX_NUMBER
,      TERMS_SEQUENCE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_DATE
,      TRX_DATE
,      DAYS_PAST_DUE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_DUE_REMAINING
,      CUST_TRX_STATUS_CODE
,      CUST_TRX_STATUS_NAME
,      INVOICE_CURRENCY_CODE
,      CUST_TRX_CLASS_CODE
,      CUST_TRX_CLASS_NAME
,      CUST_TRX_TYPE_ID
,      CUST_TRX_TYPE_NAME
,      PARTY_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ORG_ID
,      CUSTOMER_NAME
,      ACCOUNT_NUMBER
,      LOCATION
,      BILL_TO_CONTACT_ID
,      BILL_TO_FIRST_NAME
,      BILL_TO_LAST_NAME
,      PARTY_SITE_ID
,      LOCATION_ID
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_COUNTY
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY_CODE
,      BILL_TO_COUNTRY
,      BILL_TO_EMAIL_ADDRESS
,      BILL_TO_PHONE_NUMBER
,      BILL_TO_PHONE_AREA_CODE
,      BILL_TO_PHONE_COUNTRY_CODE
,      BILL_TO_PHONE_TYPE_CODE
,      BILL_TO_PHONE_TYPE_NAME
,      DOC_SEQUENCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BILL_TO_PHONE_EXTENSION
,      BILL_TO_FULL_PHONE_NUMBER
,      PURCHASE_ORDER
FROM APPS.IEX_LS_TRX_ADV_V;

Dependencies

[top of page]

APPS.IEX_LS_TRX_ADV_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymAR_PAYMENT_SCHEDULES
ViewFND_TERRITORIES_VL
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
SynonymRA_CUSTOMER_TRX
SynonymRA_CUST_TRX_TYPES

APPS.IEX_LS_TRX_ADV_V is not referenced by any database object