[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CREDIT_MEMO_S_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.AR_CREDIT_MEMO_S_V
|
| 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_ATTR1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CM_ATTR_CAT | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| CM_CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
| CM_DEF_USSGL_TRX | VARCHAR2 | (30) | Default value for the USSGL Transaction Code Flexfield | |
| CM_DEF_USSGL_TRX_CODE_CT | VARCHAR2 | (30) | Default context value for the USSGL Transaction Code Flexfield | |
| CM_DOC_SEQUENCE_ID | NUMBER | (15) | Identifies the document sequence | |
| CM_DOC_SEQUENCE_VALUE | NUMBER | (15) | The value of the document sequence | |
| CM_DOC_SEQUENCE_CATEGORY | VARCHAR2 | (20) | ||
| CM_FOB_POINT | VARCHAR2 | (30) | ||
| CM_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR10 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR11 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR12 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR13 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR14 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR15 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR16 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR17 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR18 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR19 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR20 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR8 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR9 | VARCHAR2 | (150) | ||
| CM_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | ||
| CM_INTERFACE_HEADER_ATTR1 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR10 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR11 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR12 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR13 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR14 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR15 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR2 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR3 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR4 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR5 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR6 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR7 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR8 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_ATTR9 | VARCHAR2 | (150) | ||
| CM_INTERFACE_HEADER_CT | VARCHAR2 | (30) | ||
| CM_INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
| CM_INVOICING_RULE_ID | NUMBER | (15) | ||
| CM_PRINTING_OPTION | VARCHAR2 | (20) | ||
| CM_PURCHASE_ORDER | VARCHAR2 | (50) | ||
| CM_PURCHASE_ORDER_DATE | DATE | |||
| CM_PURCHASE_ORDER_REVISION | VARCHAR2 | (50) | ||
| CM_SHIP_DATE_ACTUAL | DATE | |||
| CM_STATUS_TRX | VARCHAR2 | (30) | ||
| CM_TERM_DUE_DATE | DATE | |||
| CM_TRX_DATE | DATE | Yes | ||
| CM_TRX_NUMBER | VARCHAR2 | (20) | Yes | |
| CM_WAYBILL_NUMBER | VARCHAR2 | (50) | ||
| CM_TRX_TYPE_CUST_TRX_TYPE_ID | NUMBER | (15) | ||
| CM_TRX_TYPE_DESCRIPTION | VARCHAR2 | (80) | ||
| CM_TRX_TYPE_DRAWEE_ISSUED_FLAG | VARCHAR2 | (1) | ||
| CM_TRX_TYPE_GLOBAL_ATTR1 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR10 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR2 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR3 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR4 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR5 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR6 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR7 | VARCHAR2 | (150) | ||
| CM_TRX_TYPE_GLOBAL_ATTR_CAT | VARCHAR2 | (30) | ||
| CM_TRX_TYPE_CLEARING_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_FACTOR_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_FREIGHT_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_REC_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_REMITTANCE_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_REV_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_TAX_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_UNBILLED_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_UNEARNED_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_UNPAID_REC_CCID | NUMBER | (15) | ||
| CM_TRX_TYPE_MAG_FORMAT_CODE | VARCHAR2 | (30) | ||
| CM_TRX_TYPE_NAME | VARCHAR2 | (20) | ||
| CM_TRX_TYPE_POST_TO_GL | VARCHAR2 | (1) | ||
| CM_TRX_TYPE_CLASS | VARCHAR2 | (20) | ||
| CM_TER_DESCRIPTION | VARCHAR2 | (240) | ||
| CM_TER_NAME | VARCHAR2 | (40) | ||
| CM_TER_SEGMENT1 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT10 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT11 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT12 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT13 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT14 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT15 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT16 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT17 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT18 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT19 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT2 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT20 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT3 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT4 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT5 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT6 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT7 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT8 | VARCHAR2 | (25) | ||
| CM_TER_SEGMENT9 | VARCHAR2 | (25) | ||
| CM_TER_SUMMARY_FLAG | VARCHAR2 | (1) | ||
| CM_TER_TERRITORY_ID | NUMBER | (15) | ||
| EVENT_ID | NUMBER | (15) | ||
| CM_OPER_UNIT | NUMBER | (15) | ||
| LINE_NUMBER | NUMBER | (15) | ||
| LEDGER_ID | NUMBER | (15) | ||
| LANGUAGE | VARCHAR2 | (20) | ||
| CM_RECEIVABLE_CCID | NUMBER | |||
| XLA_PARTY_TYPE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CM_ATTR1
, CM_ATTR10
, CM_ATTR11
, CM_ATTR12
, CM_ATTR13
, CM_ATTR14
, CM_ATTR15
, CM_ATTR2
, CM_ATTR3
, CM_ATTR4
, CM_ATTR5
, CM_ATTR6
, CM_ATTR7
, CM_ATTR8
, CM_ATTR9
, CM_ATTR_CAT
, CM_CUSTOMER_TRX_ID
, CM_DEF_USSGL_TRX
, CM_DEF_USSGL_TRX_CODE_CT
, CM_DOC_SEQUENCE_ID
, CM_DOC_SEQUENCE_VALUE
, CM_DOC_SEQUENCE_CATEGORY
, CM_FOB_POINT
, CM_GLOBAL_ATTR1
, CM_GLOBAL_ATTR10
, CM_GLOBAL_ATTR11
, CM_GLOBAL_ATTR12
, CM_GLOBAL_ATTR13
, CM_GLOBAL_ATTR14
, CM_GLOBAL_ATTR15
, CM_GLOBAL_ATTR16
, CM_GLOBAL_ATTR17
, CM_GLOBAL_ATTR18
, CM_GLOBAL_ATTR19
, CM_GLOBAL_ATTR2
, CM_GLOBAL_ATTR20
, CM_GLOBAL_ATTR3
, CM_GLOBAL_ATTR4
, CM_GLOBAL_ATTR5
, CM_GLOBAL_ATTR6
, CM_GLOBAL_ATTR7
, CM_GLOBAL_ATTR8
, CM_GLOBAL_ATTR9
, CM_GLOBAL_ATTR_CAT
, CM_INTERFACE_HEADER_ATTR1
, CM_INTERFACE_HEADER_ATTR10
, CM_INTERFACE_HEADER_ATTR11
, CM_INTERFACE_HEADER_ATTR12
, CM_INTERFACE_HEADER_ATTR13
, CM_INTERFACE_HEADER_ATTR14
, CM_INTERFACE_HEADER_ATTR15
, CM_INTERFACE_HEADER_ATTR2
, CM_INTERFACE_HEADER_ATTR3
, CM_INTERFACE_HEADER_ATTR4
, CM_INTERFACE_HEADER_ATTR5
, CM_INTERFACE_HEADER_ATTR6
, CM_INTERFACE_HEADER_ATTR7
, CM_INTERFACE_HEADER_ATTR8
, CM_INTERFACE_HEADER_ATTR9
, CM_INTERFACE_HEADER_CT
, CM_INVOICE_CURRENCY_CODE
, CM_INVOICING_RULE_ID
, CM_PRINTING_OPTION
, CM_PURCHASE_ORDER
, CM_PURCHASE_ORDER_DATE
, CM_PURCHASE_ORDER_REVISION
, CM_SHIP_DATE_ACTUAL
, CM_STATUS_TRX
, CM_TERM_DUE_DATE
, CM_TRX_DATE
, CM_TRX_NUMBER
, CM_WAYBILL_NUMBER
, CM_TRX_TYPE_CUST_TRX_TYPE_ID
, CM_TRX_TYPE_DESCRIPTION
, CM_TRX_TYPE_DRAWEE_ISSUED_FLAG
, CM_TRX_TYPE_GLOBAL_ATTR1
, CM_TRX_TYPE_GLOBAL_ATTR10
, CM_TRX_TYPE_GLOBAL_ATTR2
, CM_TRX_TYPE_GLOBAL_ATTR3
, CM_TRX_TYPE_GLOBAL_ATTR4
, CM_TRX_TYPE_GLOBAL_ATTR5
, CM_TRX_TYPE_GLOBAL_ATTR6
, CM_TRX_TYPE_GLOBAL_ATTR7
, CM_TRX_TYPE_GLOBAL_ATTR_CAT
, CM_TRX_TYPE_CLEARING_CCID
, CM_TRX_TYPE_FACTOR_CCID
, CM_TRX_TYPE_FREIGHT_CCID
, CM_TRX_TYPE_REC_CCID
, CM_TRX_TYPE_REMITTANCE_CCID
, CM_TRX_TYPE_REV_CCID
, CM_TRX_TYPE_TAX_CCID
, CM_TRX_TYPE_UNBILLED_CCID
, CM_TRX_TYPE_UNEARNED_CCID
, CM_TRX_TYPE_UNPAID_REC_CCID
, CM_TRX_TYPE_MAG_FORMAT_CODE
, CM_TRX_TYPE_NAME
, CM_TRX_TYPE_POST_TO_GL
, CM_TRX_TYPE_CLASS
, CM_TER_DESCRIPTION
, CM_TER_NAME
, CM_TER_SEGMENT1
, CM_TER_SEGMENT10
, CM_TER_SEGMENT11
, CM_TER_SEGMENT12
, CM_TER_SEGMENT13
, CM_TER_SEGMENT14
, CM_TER_SEGMENT15
, CM_TER_SEGMENT16
, CM_TER_SEGMENT17
, CM_TER_SEGMENT18
, CM_TER_SEGMENT19
, CM_TER_SEGMENT2
, CM_TER_SEGMENT20
, CM_TER_SEGMENT3
, CM_TER_SEGMENT4
, CM_TER_SEGMENT5
, CM_TER_SEGMENT6
, CM_TER_SEGMENT7
, CM_TER_SEGMENT8
, CM_TER_SEGMENT9
, CM_TER_SUMMARY_FLAG
, CM_TER_TERRITORY_ID
, EVENT_ID
, CM_OPER_UNIT
, LINE_NUMBER
, LEDGER_ID
, LANGUAGE
, CM_RECEIVABLE_CCID
, XLA_PARTY_TYPE
FROM APPS.AR_CREDIT_MEMO_S_V;
APPS
AR_XLA_LINES_EXTRACT
RA_CUSTOMER_TRX_ALL
RA_CUST_TRX_TYPES_ALL
RA_RULES
RA_TERRITORIES
APPS.AR_CREDIT_MEMO_S_V is not referenced by any database object
|
|
|
|