[Home] [Help]
[Dependency Information]
Object Name: | AR_CM_LINES_L_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 | (1000) | ||
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) |
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;
|
|
|