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


VIEW: APPS.AR_TRX_REP_ITF_V

Object Details
Object Name: AR_TRX_REP_ITF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_TRX_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 Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
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 (4000)
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 (4000)
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
BATCH_NAME VARCHAR2 (50)
Batch Name
BATCH_SOURCE VARCHAR2 (50)
Batch Source
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
,      BATCH_NAME
,      BATCH_SOURCE
FROM APPS.AR_TRX_REP_ITF_V;

Dependencies

[top of page]

APPS.AR_TRX_REP_ITF_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
SynonymAR_RECEIPT_METHODS
SynonymAR_TRANSACTIONS_REP_ITF
SynonymFND_DOCUMENT_SEQUENCES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymRA_BATCHES_ALL
SynonymRA_BATCH_SOURCES_ALL
SynonymRA_CUST_TRX_TYPES_ALL
SynonymRA_TERMS

APPS.AR_TRX_REP_ITF_V is not referenced by any database object