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

VIEW: APPS.AR_TRX_DIST_LINE_REP_ITF_V

Object Details
Object Name: AR_TRX_DIST_LINE_REP_ITF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_TRX_DIST_LINE_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 (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
LINE_NUMBER NUMBER

Line Number
SUB_LINE_NUMBER NUMBER

Secondary Line Number
INVENTORY_ITEM VARCHAR2 (240)
Inventory Item
QUANTITY_INVOICED NUMBER

Quantity Invoiced
QUANTITY_ORDERED NUMBER

Quantity Ordered
QUANTITY_CREDITED NUMBER

Quantity Credited
UOM VARCHAR2 (25)
Unit of Measurements
UNIT_SELLING_PRICE NUMBER

Unit Selling Price
UNIT_STANDARD_PRICE NUMBER

Unit Standard Price
GROSS_UNIT_SELLING_PRICE NUMBER

Gross Unit Selling Price
EXTENDED_AMOUNT NUMBER
Yes Line Amount
GROSS_EXTENDED_AMOUNT NUMBER

Gross Line Amount
LINE_TYPE VARCHAR2 (80) Yes Line Type (Line/Tax/Freight/Charge)
TAX_RATE NUMBER

Tax Rate
TAX_CODE VARCHAR2 (50)
Tax Code
PERCENT NUMBER

Allocation Percent
AMOUNT NUMBER

Distribution Amount
ACCTD_AMOUNT NUMBER

Distribution Accounted Amount
ACCOUNT VARCHAR2 (240)
Account Key flexfield
ACCOUNT_DESC VARCHAR2 (240)
Account Key flexfield, description
BALANCE VARCHAR2 (240)
Balancing Segment value
BALANCE_DESC VARCHAR2 (240)
Balancing Segment description
NATACCT VARCHAR2 (240)
Natural Account Segment value
NATACCT_DESC VARCHAR2 (240)
Natural Account Segment description
ACCOUNT_CLASS VARCHAR2 (80) Yes Account Class (Receivables/Revenue/Tax/etc.)
GL_DATE DATE

Accounted Date
POSTED_FLAG VARCHAR2 (80) Yes Posted to GL flag
POSTED_DATE DATE

Posted Date
TRX_LAST_UPDATED_BY VARCHAR2 (100) Yes Transaction last updated by
TRX_LAST_UPDATE_DATE DATE

Transaction last update date
ACCOUNTING_RULE_NAME VARCHAR2 (30)
Accounting rule name
ACCOUNTING_RULE_DURATION NUMBER (15)
Accounting rule duration
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
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
,      LINE_NUMBER
,      SUB_LINE_NUMBER
,      INVENTORY_ITEM
,      QUANTITY_INVOICED
,      QUANTITY_ORDERED
,      QUANTITY_CREDITED
,      UOM
,      UNIT_SELLING_PRICE
,      UNIT_STANDARD_PRICE
,      GROSS_UNIT_SELLING_PRICE
,      EXTENDED_AMOUNT
,      GROSS_EXTENDED_AMOUNT
,      LINE_TYPE
,      TAX_RATE
,      TAX_CODE
,      PERCENT
,      AMOUNT
,      ACCTD_AMOUNT
,      ACCOUNT
,      ACCOUNT_DESC
,      BALANCE
,      BALANCE_DESC
,      NATACCT
,      NATACCT_DESC
,      ACCOUNT_CLASS
,      GL_DATE
,      POSTED_FLAG
,      POSTED_DATE
,      TRX_LAST_UPDATED_BY
,      TRX_LAST_UPDATE_DATE
,      ACCOUNTING_RULE_NAME
,      ACCOUNTING_RULE_DURATION
,      ITEM_DESCRIPTION
FROM APPS.AR_TRX_DIST_LINE_REP_ITF_V;

Dependencies

[top of page]

APPS.AR_TRX_DIST_LINE_REP_ITF_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymAR_RECEIPT_METHODS
SynonymAR_TRANSACTIONS_REP_ITF
SynonymAR_VAT_TAX_ALL
SynonymFND_DOCUMENT_SEQUENCES
SynonymFND_USER
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymMTL_UNITS_OF_MEASURE
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_CUST_TRX_LINE_GL_DIST_ALL
SynonymRA_CUST_TRX_TYPES_ALL
SynonymRA_RULES
SynonymRA_TERMS

APPS.AR_TRX_DIST_LINE_REP_ITF_V is not referenced by any database object