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


VIEW: APPS.AR_CM_LINES_L_V

Object Details
Object Name: AR_CM_LINES_L_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_CM_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
CM_LINE_ACCT_RULE_DURATION NUMBER (15)
CM_LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 (1)
CM_LINE_ATTR1 VARCHAR2 (150)
CM_LINE_ATTR10 VARCHAR2 (150)
CM_LINE_ATTR11 VARCHAR2 (150)
CM_LINE_ATTR12 VARCHAR2 (150)
CM_LINE_ATTR13 VARCHAR2 (150)
CM_LINE_ATTR14 VARCHAR2 (150)
CM_LINE_ATTR15 VARCHAR2 (150)
CM_LINE_ATTR2 VARCHAR2 (150)
CM_LINE_ATTR3 VARCHAR2 (150)
CM_LINE_ATTR4 VARCHAR2 (150)
CM_LINE_ATTR5 VARCHAR2 (150)
CM_LINE_ATTR6 VARCHAR2 (150)
CM_LINE_ATTR7 VARCHAR2 (150)
CM_LINE_ATTR8 VARCHAR2 (150)
CM_LINE_ATTR9 VARCHAR2 (150)
CM_LINE_ATTR_CAT VARCHAR2 (30)
CM_LINE_CUSTOMER_TRX_LINE_ID NUMBER (15)
CM_LINE_DESCRIPTION VARCHAR2 (240)
CM_LINE_GLOBAL_ATTR1 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR10 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR11 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR12 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR13 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR14 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR15 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR16 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR17 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR18 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR19 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR2 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR20 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR3 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR4 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR5 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR6 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR7 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR8 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR9 VARCHAR2 (150)
CM_LINE_GLOBAL_ATTR_CAT VARCHAR2 (30)
CM_LINE_GROSS_UNIT_SELL_PRICE NUMBER

CM_LINE_INTERFACE_LINE_ATTR1 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR10 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR11 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR12 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR13 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR14 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR15 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR2 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR3 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR4 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR5 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR6 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR7 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR8 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_ATTR9 VARCHAR2 (150)
CM_LINE_INTERFACE_LINE_CT VARCHAR2 (30)
CM_LINE_ITEM_CT VARCHAR2 (30)
CM_LINE_LINE_NUMBER NUMBER

CM_LINE_LINE_TYPE VARCHAR2 (20)
CM_LINE_QUANTITY_CREDITED NUMBER

CM_LINE_QUANTITY_INVOICED NUMBER

CM_LINE_QUANTITY_ORDERED NUMBER

CM_LINE_REASON_CODE VARCHAR2 (30)
CM_LINE_RULE_START_DATE DATE

CM_LINE_SALES_ORDER VARCHAR2 (50)
CM_LINE_SALES_ORDER_DATE DATE

CM_LINE_SALES_ORDER_LINE VARCHAR2 (30)
CM_LINE_SALES_ORDER_SOURCE VARCHAR2 (50)
CM_LINE_TAX_EXEMPT_FLAG VARCHAR2 (1)
CM_LINE_TAX_EXEMPT_NUMBER VARCHAR2 (80)
CM_LINE_TAX_EXMPT_REASON_CODE VARCHAR2 (30)
CM_LINE_TAX_PRECEDENCE NUMBER

CM_LINE_TAX_RATE NUMBER

CM_LINE_TRANSLATED_DESC VARCHAR2 (240)
CM_LINE_UNIT_SELLING_PRICE NUMBER

CM_LINE_UNIT_STANDARD_PRICE NUMBER

CM_LINE_UOM_CODE VARCHAR2 (3)
CM_LINE_DIST_ACCOUNT_CLASS VARCHAR2 (20) Yes
CM_LINE_DIST_AMT NUMBER

CM_LINE_DIST_ATTR1 VARCHAR2 (150)
CM_LINE_DIST_ATTR10 VARCHAR2 (150)
CM_LINE_DIST_ATTR11 VARCHAR2 (150)
CM_LINE_DIST_ATTR12 VARCHAR2 (150)
CM_LINE_DIST_ATTR13 VARCHAR2 (150)
CM_LINE_DIST_ATTR14 VARCHAR2 (150)
CM_LINE_DIST_ATTR15 VARCHAR2 (150)
CM_LINE_DIST_ATTR2 VARCHAR2 (150)
CM_LINE_DIST_ATTR3 VARCHAR2 (150)
CM_LINE_DIST_ATTR4 VARCHAR2 (150)
CM_LINE_DIST_ATTR5 VARCHAR2 (150)
CM_LINE_DIST_ATTR6 VARCHAR2 (150)
CM_LINE_DIST_ATTR7 VARCHAR2 (150)
CM_LINE_DIST_ATTR8 VARCHAR2 (150)
CM_LINE_DIST_ATTR9 VARCHAR2 (150)
CM_LINE_DIST_ATTR_CAT VARCHAR2 (30)
CM_LINE_DIST_CCSEG VARCHAR2 (240)
CM_LINE_DIST_CCID NUMBER (15) Yes
CM_LINE_DIST_COL_TAX_CCID NUMBER (15)
CM_LINE_DIST_COL_TAX_CCSEG VARCHAR2 (240)
CM_LINE_DIST_COMMENTS VARCHAR2 (240)
CM_LINE_DIST_ID NUMBER (15)
CM_LINE_DIST_GL_DATE DATE

CM_LINE_DIST_PERCENT NUMBER

CM_LINE_DIST_REV_ADJ_CLASS VARCHAR2 (30)
CM_LINE_DIST_USSGL_CODE VARCHAR2 (30)
CM_LINE_DIST_USSGL_CODE_CT VARCHAR2 (30)
CM_LINE_DIST_PAIRED_CCID NUMBER

CM_MEMO_LINE_GLOBAL_ATTR1 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR2 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR3 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR4 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR5 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR6 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR7 VARCHAR2 (150)
CM_MEMO_LINE_GLOBAL_ATTR_CAT VARCHAR2 (150)
CM_MEMO_LINE_REV_CCID NUMBER (15)
CM_MEMO_LINE_TYPE VARCHAR2 (30)
CM_MEMO_LINE_ID NUMBER (15)
CM_MEMO_LINE_TAX_CODE VARCHAR2 (50)
CM_MEMO_LINE_UNIT_STD_PRICE NUMBER

CM_MEMO_LINE_UOM_CODE VARCHAR2 (3)
CM_ACCT_RULE_DEFERRED_REV_FLAG VARCHAR2 (1)
CM_ACCT_RULE_DESCRIPTION VARCHAR2 (80)
CM_ACCT_RULE_FREQUENCY VARCHAR2 (15)
CM_ACCT_RULE_NAME VARCHAR2 (30)
CM_ACCT_RULE_OCCURRENCES NUMBER

CM_ACCT_RULE_ID NUMBER (15)
CM_ACCT_RULE_TYPE VARCHAR2 (10)
CM_DISTRIBUTION_TYPE CHAR (28)
EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LANGUAGE VARCHAR2 (20)
LEDGER_ID NUMBER (15)
CM_LINE_DIST_PAIRED_ACC_CLASS VARCHAR2 (20)
CM_TAX_LINE_ID NUMBER (15)
Query Text

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


SELECT CM_LINE_ACCT_RULE_DURATION
,      CM_LINE_AMT_INCLUDES_TAX_FLAG
,      CM_LINE_ATTR1
,      CM_LINE_ATTR10
,      CM_LINE_ATTR11
,      CM_LINE_ATTR12
,      CM_LINE_ATTR13
,      CM_LINE_ATTR14
,      CM_LINE_ATTR15
,      CM_LINE_ATTR2
,      CM_LINE_ATTR3
,      CM_LINE_ATTR4
,      CM_LINE_ATTR5
,      CM_LINE_ATTR6
,      CM_LINE_ATTR7
,      CM_LINE_ATTR8
,      CM_LINE_ATTR9
,      CM_LINE_ATTR_CAT
,      CM_LINE_CUSTOMER_TRX_LINE_ID
,      CM_LINE_DESCRIPTION
,      CM_LINE_GLOBAL_ATTR1
,      CM_LINE_GLOBAL_ATTR10
,      CM_LINE_GLOBAL_ATTR11
,      CM_LINE_GLOBAL_ATTR12
,      CM_LINE_GLOBAL_ATTR13
,      CM_LINE_GLOBAL_ATTR14
,      CM_LINE_GLOBAL_ATTR15
,      CM_LINE_GLOBAL_ATTR16
,      CM_LINE_GLOBAL_ATTR17
,      CM_LINE_GLOBAL_ATTR18
,      CM_LINE_GLOBAL_ATTR19
,      CM_LINE_GLOBAL_ATTR2
,      CM_LINE_GLOBAL_ATTR20
,      CM_LINE_GLOBAL_ATTR3
,      CM_LINE_GLOBAL_ATTR4
,      CM_LINE_GLOBAL_ATTR5
,      CM_LINE_GLOBAL_ATTR6
,      CM_LINE_GLOBAL_ATTR7
,      CM_LINE_GLOBAL_ATTR8
,      CM_LINE_GLOBAL_ATTR9
,      CM_LINE_GLOBAL_ATTR_CAT
,      CM_LINE_GROSS_UNIT_SELL_PRICE
,      CM_LINE_INTERFACE_LINE_ATTR1
,      CM_LINE_INTERFACE_LINE_ATTR10
,      CM_LINE_INTERFACE_LINE_ATTR11
,      CM_LINE_INTERFACE_LINE_ATTR12
,      CM_LINE_INTERFACE_LINE_ATTR13
,      CM_LINE_INTERFACE_LINE_ATTR14
,      CM_LINE_INTERFACE_LINE_ATTR15
,      CM_LINE_INTERFACE_LINE_ATTR2
,      CM_LINE_INTERFACE_LINE_ATTR3
,      CM_LINE_INTERFACE_LINE_ATTR4
,      CM_LINE_INTERFACE_LINE_ATTR5
,      CM_LINE_INTERFACE_LINE_ATTR6
,      CM_LINE_INTERFACE_LINE_ATTR7
,      CM_LINE_INTERFACE_LINE_ATTR8
,      CM_LINE_INTERFACE_LINE_ATTR9
,      CM_LINE_INTERFACE_LINE_CT
,      CM_LINE_ITEM_CT
,      CM_LINE_LINE_NUMBER
,      CM_LINE_LINE_TYPE
,      CM_LINE_QUANTITY_CREDITED
,      CM_LINE_QUANTITY_INVOICED
,      CM_LINE_QUANTITY_ORDERED
,      CM_LINE_REASON_CODE
,      CM_LINE_RULE_START_DATE
,      CM_LINE_SALES_ORDER
,      CM_LINE_SALES_ORDER_DATE
,      CM_LINE_SALES_ORDER_LINE
,      CM_LINE_SALES_ORDER_SOURCE
,      CM_LINE_TAX_EXEMPT_FLAG
,      CM_LINE_TAX_EXEMPT_NUMBER
,      CM_LINE_TAX_EXMPT_REASON_CODE
,      CM_LINE_TAX_PRECEDENCE
,      CM_LINE_TAX_RATE
,      CM_LINE_TRANSLATED_DESC
,      CM_LINE_UNIT_SELLING_PRICE
,      CM_LINE_UNIT_STANDARD_PRICE
,      CM_LINE_UOM_CODE
,      CM_LINE_DIST_ACCOUNT_CLASS
,      CM_LINE_DIST_AMT
,      CM_LINE_DIST_ATTR1
,      CM_LINE_DIST_ATTR10
,      CM_LINE_DIST_ATTR11
,      CM_LINE_DIST_ATTR12
,      CM_LINE_DIST_ATTR13
,      CM_LINE_DIST_ATTR14
,      CM_LINE_DIST_ATTR15
,      CM_LINE_DIST_ATTR2
,      CM_LINE_DIST_ATTR3
,      CM_LINE_DIST_ATTR4
,      CM_LINE_DIST_ATTR5
,      CM_LINE_DIST_ATTR6
,      CM_LINE_DIST_ATTR7
,      CM_LINE_DIST_ATTR8
,      CM_LINE_DIST_ATTR9
,      CM_LINE_DIST_ATTR_CAT
,      CM_LINE_DIST_CCSEG
,      CM_LINE_DIST_CCID
,      CM_LINE_DIST_COL_TAX_CCID
,      CM_LINE_DIST_COL_TAX_CCSEG
,      CM_LINE_DIST_COMMENTS
,      CM_LINE_DIST_ID
,      CM_LINE_DIST_GL_DATE
,      CM_LINE_DIST_PERCENT
,      CM_LINE_DIST_REV_ADJ_CLASS
,      CM_LINE_DIST_USSGL_CODE
,      CM_LINE_DIST_USSGL_CODE_CT
,      CM_LINE_DIST_PAIRED_CCID
,      CM_MEMO_LINE_GLOBAL_ATTR1
,      CM_MEMO_LINE_GLOBAL_ATTR2
,      CM_MEMO_LINE_GLOBAL_ATTR3
,      CM_MEMO_LINE_GLOBAL_ATTR4
,      CM_MEMO_LINE_GLOBAL_ATTR5
,      CM_MEMO_LINE_GLOBAL_ATTR6
,      CM_MEMO_LINE_GLOBAL_ATTR7
,      CM_MEMO_LINE_GLOBAL_ATTR_CAT
,      CM_MEMO_LINE_REV_CCID
,      CM_MEMO_LINE_TYPE
,      CM_MEMO_LINE_ID
,      CM_MEMO_LINE_TAX_CODE
,      CM_MEMO_LINE_UNIT_STD_PRICE
,      CM_MEMO_LINE_UOM_CODE
,      CM_ACCT_RULE_DEFERRED_REV_FLAG
,      CM_ACCT_RULE_DESCRIPTION
,      CM_ACCT_RULE_FREQUENCY
,      CM_ACCT_RULE_NAME
,      CM_ACCT_RULE_OCCURRENCES
,      CM_ACCT_RULE_ID
,      CM_ACCT_RULE_TYPE
,      CM_DISTRIBUTION_TYPE
,      EVENT_ID
,      LINE_NUMBER
,      LANGUAGE
,      LEDGER_ID
,      CM_LINE_DIST_PAIRED_ACC_CLASS
,      CM_TAX_LINE_ID
FROM APPS.AR_CM_LINES_L_V;

Dependencies

[top of page]

APPS.AR_CM_LINES_L_V references the following:

SchemaAPPS
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_CM_LINES_L_V is referenced by following:

SchemaAPPS
ViewOKL_AR_CM_LINES_L_V
Package BodyXLA_00222_AAD_S_000002_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