eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AR_TRX_SCHEDULES_REP_ITF_V

Object Details

Object Name:	AR_TRX_SCHEDULES_REP_ITF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_TRX_SCHEDULES_REP_ITF_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID of base table. Needed for INSTEAD OF DELETE trigger.
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
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).
ORGANIZATION_NAME	VARCHAR2	(30)		Set of Books Name
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional Currency Code
TRX_NUMBER	VARCHAR2	(20)		Transaction Number
TRX_CLASS	VARCHAR2	(80)	Yes	Transaction Class
TRX_TYPE	VARCHAR2	(20)		Transaction Type
CONS_BILL_NUMBER	VARCHAR2	(30)		Consolidated Billing Number
TRX_DATE	DATE			Transaction Date
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(50)		Ship-to Customer Name
SHIP_TO_CUSTOMER_NAME_PHONETIC	VARCHAR2	(320)		Ship-to Customer Name Phonetic
SHIP_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Ship-to Customer Number
SHIP_TO_CUSTOMER_SITE	VARCHAR2	(40)		Ship-to Customer Site Name
BILL_TO_CUSTOMER_NAME	VARCHAR2	(50)		Bill-to Customer Number
BILL_TO_CUSTOMER_NAME_PHONETIC	VARCHAR2	(320)		Bill-to Customer Name Phonetic
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
BILL_TO_CUSTOMER_SITE	VARCHAR2	(40)	Yes	Bill-to Customer Site Name
TRX_CURRENCY	VARCHAR2	(15)		Transaction Currency Code
EXCHANGE_RATE	NUMBER			Exchange Rate
EXCHANGE_DATE	DATE			Exchange Date
EXCHANGE_TYPE	VARCHAR2	(30)		Exchange Type
RECEIVABLES_GL_DATE	DATE			Receivables GL Date
REC_ACCOUNT	VARCHAR2	(240)		Receivables Account
REC_ACCOUNT_DESC	VARCHAR2	(240)		Receivables Account Description
REC_BALANCE	VARCHAR2	(240)		Receivables Balancing Segment
REC_BALANCE_DESC	VARCHAR2	(240)		Receivables Balancing Segment Description
REC_NATACCT	VARCHAR2	(240)		Receivables Natural Account
REC_NATACCT_DESC	VARCHAR2	(240)		Receivables Natural Account Description
REC_POSTABLE_FLAG	VARCHAR2	(10)		Receivables Postable Flag
PAYMENT_TERMS	VARCHAR2	(15)		Payment Terms
TRX_DUE_DATE	DATE			Transaction Due Date
TAX_CALCULATION_LEVEL	VARCHAR2	(80)	Yes	Tax Calculation Level
DOC_SEQUENCE_NAME	VARCHAR2	(30)		Document Sequence Name
DOC_SEQUENCE_VALUE	NUMBER			Document Sequence Value
TRX_AMOUNT	NUMBER			Transaction Amount
TRX_ACCTD_AMOUNT	NUMBER			Transaction Accounted Amount
PAYMENT_METHOD	VARCHAR2	(30)		Payment Method
SCHEDULED_DUE_DATE	DATE		Yes	Payment Schedule Due Date
ORIGINAL_AMOUNT	NUMBER		Yes	Payment Schedule Original Amount
SCHEDULED_AMOUNT	NUMBER		Yes	Payment Schedule Amount Due

Query Text

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


SELECT ROW_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      TRX_NUMBER
,      TRX_CLASS
,      TRX_TYPE
,      CONS_BILL_NUMBER
,      TRX_DATE
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_CUSTOMER_NAME_PHONETIC
,      SHIP_TO_CUSTOMER_NUMBER
,      SHIP_TO_CUSTOMER_SITE
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CUSTOMER_NAME_PHONETIC
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_SITE
,      TRX_CURRENCY
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_TYPE
,      RECEIVABLES_GL_DATE
,      REC_ACCOUNT
,      REC_ACCOUNT_DESC
,      REC_BALANCE
,      REC_BALANCE_DESC
,      REC_NATACCT
,      REC_NATACCT_DESC
,      REC_POSTABLE_FLAG
,      PAYMENT_TERMS
,      TRX_DUE_DATE
,      TAX_CALCULATION_LEVEL
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      TRX_AMOUNT
,      TRX_ACCTD_AMOUNT
,      PAYMENT_METHOD
,      SCHEDULED_DUE_DATE
,      ORIGINAL_AMOUNT
,      SCHEDULED_AMOUNT
FROM APPS.AR_TRX_SCHEDULES_REP_ITF_V;

Dependencies

[top of page]

APPS.AR_TRX_SCHEDULES_REP_ITF_V references the following:

APPS: AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIPT_METHODS; AR_TRANSACTIONS_REP_ITF; FND_DOCUMENT_SEQUENCES; HZ_CUST_ACCOUNTS; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; RA_CUST_TRX_TYPES_ALL; RA_TERMS

APPS.AR_TRX_SCHEDULES_REP_ITF_V is not referenced by any database object