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


VIEW: APPS.AR_CUST_TRX_LINES_L_V

Object Details
Object Name: AR_CUST_TRX_LINES_L_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_CUST_TRX_LINES_L_V
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
TRX_LINE_ACCT_RULE_DURATION NUMBER

TRX_LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 (1)
TRX_LINE_ATTR1 VARCHAR2 (150)
TRX_LINE_ATTR10 VARCHAR2 (150)
TRX_LINE_ATTR11 VARCHAR2 (150)
TRX_LINE_ATTR12 VARCHAR2 (150)
TRX_LINE_ATTR13 VARCHAR2 (150)
TRX_LINE_ATTR14 VARCHAR2 (150)
TRX_LINE_ATTR15 VARCHAR2 (150)
TRX_LINE_ATTR2 VARCHAR2 (150)
TRX_LINE_ATTR3 VARCHAR2 (150)
TRX_LINE_ATTR4 VARCHAR2 (150)
TRX_LINE_ATTR5 VARCHAR2 (150)
TRX_LINE_ATTR6 VARCHAR2 (150)
TRX_LINE_ATTR7 VARCHAR2 (150)
TRX_LINE_ATTR8 VARCHAR2 (150)
TRX_LINE_ATTR9 VARCHAR2 (150)
TRX_LINE_ATTR_CAT VARCHAR2 (30)
TRX_LINE_CUSTOMER_TRX_LINE_ID NUMBER (15)
TRX_LINE_DESCRIPTION VARCHAR2 (240)
TRX_LINE_GLOBAL_ATTR1 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR10 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR11 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR12 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR13 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR14 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR15 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR16 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR17 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR18 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR19 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR2 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR20 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR3 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR4 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR5 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR6 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR7 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR8 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR9 VARCHAR2 (150)
TRX_LINE_GLOBAL_ATTR_CAT VARCHAR2 (150)
TRX_LINE_GROSS_UNIT_SELL_PRICE NUMBER

TRX_LINE_INTERFACE_LINE_ATTR1 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR10 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR11 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR12 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR13 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR14 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR15 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR2 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR3 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR4 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR5 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR6 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR7 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR8 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_ATTR9 VARCHAR2 (150)
TRX_LINE_INTERFACE_LINE_CT VARCHAR2 (30)
TRX_LINE_ITEM_CT VARCHAR2 (30)
TRX_LINE_LINE_NUMBER NUMBER

TRX_LINE_LINE_TYPE VARCHAR2 (20)
TRX_LINE_QUANTITY_CREDITED NUMBER

TRX_LINE_QUANTITY_INVOICED NUMBER

TRX_LINE_QUANTITY_ORDERED NUMBER

TRX_LINE_REASON_CODE VARCHAR2 (30)
TRX_LINE_RULE_START_DATE DATE

TRX_LINE_SALES_ORDER VARCHAR2 (50)
TRX_LINE_SALES_ORDER_DATE DATE

TRX_LINE_SALES_ORDER_LINE VARCHAR2 (30)
TRX_LINE_SALES_ORDER_SOURCE VARCHAR2 (50)
TRX_LINE_TAX_EXEMPT_FLAG VARCHAR2 (1)
TRX_LINE_TAX_EXEMPT_NUMBER VARCHAR2 (80)
TRX_LINE_TAX_EXMPT_REASON_CODE VARCHAR2 (30)
TRX_LINE_TAX_PRECEDENCE NUMBER

TRX_LINE_TAX_RATE NUMBER

TRX_LINE_TRANSLATED_DESC VARCHAR2 (240)
TRX_LINE_UNIT_SELLING_PRICE NUMBER

TRX_LINE_UNIT_STANDARD_PRICE NUMBER

TRX_LINE_UOM_CODE VARCHAR2 (3)
TRX_LINE_DIST_ACCOUNT_CLASS VARCHAR2 (20)
TRX_LINE_DIST_AMT NUMBER

TRX_LINE_DIST_ATTR1 VARCHAR2 (150)
TRX_LINE_DIST_ATTR10 VARCHAR2 (150)
TRX_LINE_DIST_ATTR11 VARCHAR2 (150)
TRX_LINE_DIST_ATTR12 VARCHAR2 (150)
TRX_LINE_DIST_ATTR13 VARCHAR2 (150)
TRX_LINE_DIST_ATTR14 VARCHAR2 (150)
TRX_LINE_DIST_ATTR15 VARCHAR2 (150)
TRX_LINE_DIST_ATTR2 VARCHAR2 (150)
TRX_LINE_DIST_ATTR3 VARCHAR2 (150)
TRX_LINE_DIST_ATTR4 VARCHAR2 (150)
TRX_LINE_DIST_ATTR5 VARCHAR2 (150)
TRX_LINE_DIST_ATTR6 VARCHAR2 (150)
TRX_LINE_DIST_ATTR7 VARCHAR2 (150)
TRX_LINE_DIST_ATTR8 VARCHAR2 (150)
TRX_LINE_DIST_ATTR9 VARCHAR2 (150)
TRX_LINE_DIST_ATTR_CAT VARCHAR2 (30)
TRX_LINE_DIST_CCSEG VARCHAR2 (240)
TRX_LINE_DIST_CCID NUMBER (15)
TRX_LINE_DIST_COL_TAX_CCID NUMBER

TRX_LINE_DIST_COL_TAX_CCSEG VARCHAR2 (240)
TRX_LINE_DIST_COMMENTS VARCHAR2 (240)
TRX_LINE_DIST_ID NUMBER (15)
TRX_LINE_DIST_GL_DATE DATE

TRX_LINE_DIST_PERCENT NUMBER

TRX_LINE_DIST_REV_ADJ_CLASS VARCHAR2 (30)
TRX_LINE_DIST_USSGL_CODE VARCHAR2 (30)
TRX_LINE_DIST_USSGL_CODE_CT VARCHAR2 (30)
TRX_LINE_DIST_PAIRED_CCID NUMBER

MEMO_LINE_GLOBAL_ATTR1 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR2 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR3 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR4 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR5 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR6 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR7 VARCHAR2 (150)
MEMO_LINE_GLOBAL_ATTR_CAT VARCHAR2 (150)
MEMO_LINE_REV_CCID NUMBER

MEMO_LINE_TYPE VARCHAR2 (30)
MEMO_LINE_ID NUMBER

MEMO_LINE_TAX_CODE VARCHAR2 (50)
MEMO_LINE_UNIT_STD_PRICE NUMBER

MEMO_LINE_UOM_CODE VARCHAR2 (3)
ACCT_RULE_DEFERRED_REV_FLAG VARCHAR2 (1)
ACCT_RULE_DESCRIPTION VARCHAR2 (80)
ACCT_RULE_FREQUENCY VARCHAR2 (15)
ACCT_RULE_NAME VARCHAR2 (30)
ACCT_RULE_OCCURRENCES NUMBER

ACCT_RULE_ID NUMBER

ACCT_RULE_TYPE VARCHAR2 (10)
TRX_DISTRIBUTION_TYPE VARCHAR2 (28)
EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LANGUAGE VARCHAR2 (20)
LEDGER_ID NUMBER (15)
TRX_LINE_DIST_PAIRED_ACC_CLASS VARCHAR2 (20)
TRX_TAX_LINE_ID NUMBER

TRX_LINE_TAX_CLASS_CODE VARCHAR2 (50)
Query Text

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


SELECT TRX_LINE_ACCT_RULE_DURATION
,      TRX_LINE_AMT_INCLUDES_TAX_FLAG
,      TRX_LINE_ATTR1
,      TRX_LINE_ATTR10
,      TRX_LINE_ATTR11
,      TRX_LINE_ATTR12
,      TRX_LINE_ATTR13
,      TRX_LINE_ATTR14
,      TRX_LINE_ATTR15
,      TRX_LINE_ATTR2
,      TRX_LINE_ATTR3
,      TRX_LINE_ATTR4
,      TRX_LINE_ATTR5
,      TRX_LINE_ATTR6
,      TRX_LINE_ATTR7
,      TRX_LINE_ATTR8
,      TRX_LINE_ATTR9
,      TRX_LINE_ATTR_CAT
,      TRX_LINE_CUSTOMER_TRX_LINE_ID
,      TRX_LINE_DESCRIPTION
,      TRX_LINE_GLOBAL_ATTR1
,      TRX_LINE_GLOBAL_ATTR10
,      TRX_LINE_GLOBAL_ATTR11
,      TRX_LINE_GLOBAL_ATTR12
,      TRX_LINE_GLOBAL_ATTR13
,      TRX_LINE_GLOBAL_ATTR14
,      TRX_LINE_GLOBAL_ATTR15
,      TRX_LINE_GLOBAL_ATTR16
,      TRX_LINE_GLOBAL_ATTR17
,      TRX_LINE_GLOBAL_ATTR18
,      TRX_LINE_GLOBAL_ATTR19
,      TRX_LINE_GLOBAL_ATTR2
,      TRX_LINE_GLOBAL_ATTR20
,      TRX_LINE_GLOBAL_ATTR3
,      TRX_LINE_GLOBAL_ATTR4
,      TRX_LINE_GLOBAL_ATTR5
,      TRX_LINE_GLOBAL_ATTR6
,      TRX_LINE_GLOBAL_ATTR7
,      TRX_LINE_GLOBAL_ATTR8
,      TRX_LINE_GLOBAL_ATTR9
,      TRX_LINE_GLOBAL_ATTR_CAT
,      TRX_LINE_GROSS_UNIT_SELL_PRICE
,      TRX_LINE_INTERFACE_LINE_ATTR1
,      TRX_LINE_INTERFACE_LINE_ATTR10
,      TRX_LINE_INTERFACE_LINE_ATTR11
,      TRX_LINE_INTERFACE_LINE_ATTR12
,      TRX_LINE_INTERFACE_LINE_ATTR13
,      TRX_LINE_INTERFACE_LINE_ATTR14
,      TRX_LINE_INTERFACE_LINE_ATTR15
,      TRX_LINE_INTERFACE_LINE_ATTR2
,      TRX_LINE_INTERFACE_LINE_ATTR3
,      TRX_LINE_INTERFACE_LINE_ATTR4
,      TRX_LINE_INTERFACE_LINE_ATTR5
,      TRX_LINE_INTERFACE_LINE_ATTR6
,      TRX_LINE_INTERFACE_LINE_ATTR7
,      TRX_LINE_INTERFACE_LINE_ATTR8
,      TRX_LINE_INTERFACE_LINE_ATTR9
,      TRX_LINE_INTERFACE_LINE_CT
,      TRX_LINE_ITEM_CT
,      TRX_LINE_LINE_NUMBER
,      TRX_LINE_LINE_TYPE
,      TRX_LINE_QUANTITY_CREDITED
,      TRX_LINE_QUANTITY_INVOICED
,      TRX_LINE_QUANTITY_ORDERED
,      TRX_LINE_REASON_CODE
,      TRX_LINE_RULE_START_DATE
,      TRX_LINE_SALES_ORDER
,      TRX_LINE_SALES_ORDER_DATE
,      TRX_LINE_SALES_ORDER_LINE
,      TRX_LINE_SALES_ORDER_SOURCE
,      TRX_LINE_TAX_EXEMPT_FLAG
,      TRX_LINE_TAX_EXEMPT_NUMBER
,      TRX_LINE_TAX_EXMPT_REASON_CODE
,      TRX_LINE_TAX_PRECEDENCE
,      TRX_LINE_TAX_RATE
,      TRX_LINE_TRANSLATED_DESC
,      TRX_LINE_UNIT_SELLING_PRICE
,      TRX_LINE_UNIT_STANDARD_PRICE
,      TRX_LINE_UOM_CODE
,      TRX_LINE_DIST_ACCOUNT_CLASS
,      TRX_LINE_DIST_AMT
,      TRX_LINE_DIST_ATTR1
,      TRX_LINE_DIST_ATTR10
,      TRX_LINE_DIST_ATTR11
,      TRX_LINE_DIST_ATTR12
,      TRX_LINE_DIST_ATTR13
,      TRX_LINE_DIST_ATTR14
,      TRX_LINE_DIST_ATTR15
,      TRX_LINE_DIST_ATTR2
,      TRX_LINE_DIST_ATTR3
,      TRX_LINE_DIST_ATTR4
,      TRX_LINE_DIST_ATTR5
,      TRX_LINE_DIST_ATTR6
,      TRX_LINE_DIST_ATTR7
,      TRX_LINE_DIST_ATTR8
,      TRX_LINE_DIST_ATTR9
,      TRX_LINE_DIST_ATTR_CAT
,      TRX_LINE_DIST_CCSEG
,      TRX_LINE_DIST_CCID
,      TRX_LINE_DIST_COL_TAX_CCID
,      TRX_LINE_DIST_COL_TAX_CCSEG
,      TRX_LINE_DIST_COMMENTS
,      TRX_LINE_DIST_ID
,      TRX_LINE_DIST_GL_DATE
,      TRX_LINE_DIST_PERCENT
,      TRX_LINE_DIST_REV_ADJ_CLASS
,      TRX_LINE_DIST_USSGL_CODE
,      TRX_LINE_DIST_USSGL_CODE_CT
,      TRX_LINE_DIST_PAIRED_CCID
,      MEMO_LINE_GLOBAL_ATTR1
,      MEMO_LINE_GLOBAL_ATTR2
,      MEMO_LINE_GLOBAL_ATTR3
,      MEMO_LINE_GLOBAL_ATTR4
,      MEMO_LINE_GLOBAL_ATTR5
,      MEMO_LINE_GLOBAL_ATTR6
,      MEMO_LINE_GLOBAL_ATTR7
,      MEMO_LINE_GLOBAL_ATTR_CAT
,      MEMO_LINE_REV_CCID
,      MEMO_LINE_TYPE
,      MEMO_LINE_ID
,      MEMO_LINE_TAX_CODE
,      MEMO_LINE_UNIT_STD_PRICE
,      MEMO_LINE_UOM_CODE
,      ACCT_RULE_DEFERRED_REV_FLAG
,      ACCT_RULE_DESCRIPTION
,      ACCT_RULE_FREQUENCY
,      ACCT_RULE_NAME
,      ACCT_RULE_OCCURRENCES
,      ACCT_RULE_ID
,      ACCT_RULE_TYPE
,      TRX_DISTRIBUTION_TYPE
,      EVENT_ID
,      LINE_NUMBER
,      LANGUAGE
,      LEDGER_ID
,      TRX_LINE_DIST_PAIRED_ACC_CLASS
,      TRX_TAX_LINE_ID
,      TRX_LINE_TAX_CLASS_CODE
FROM APPS.AR_CUST_TRX_LINES_L_V;

Dependencies

[top of page]

APPS.AR_CUST_TRX_LINES_L_V references the following:

SchemaAPPS
SynonymAR_ADJUSTMENTS_ALL
SynonymAR_DISTRIBUTIONS_ALL
SynonymAR_MEMO_LINES_ALL_B
SynonymAR_XLA_LINES_EXTRACT
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_CUST_TRX_LINE_GL_DIST_ALL
SynonymRA_RULES
APPS.AR_CUST_TRX_LINES_L_V is referenced by following:

SchemaAPPS
Package BodyFV_SLA_AR_PROCESSING_PKG - show dependent code
ViewOKL_AR_CUST_TRX_LINES_L_V
Package BodyXLA_00222_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000004_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000005_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000006_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000007_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000008_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000009_PKG - show dependent code
Package BodyXLA_00222_AAD_S_000017_PKG - show dependent code