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


VIEW: APPS.AR_CREDIT_MEMO_H_V

Object Details
Object Name: AR_CREDIT_MEMO_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_CREDIT_MEMO_H_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_ATTR1 VARCHAR2 (150)
CM_ATTR10 VARCHAR2 (150)
CM_ATTR11 VARCHAR2 (150)
CM_ATTR12 VARCHAR2 (150)
CM_ATTR13 VARCHAR2 (150)
CM_ATTR14 VARCHAR2 (150)
CM_ATTR15 VARCHAR2 (150)
CM_ATTR2 VARCHAR2 (150)
CM_ATTR3 VARCHAR2 (150)
CM_ATTR4 VARCHAR2 (150)
CM_ATTR5 VARCHAR2 (150)
CM_ATTR6 VARCHAR2 (150)
CM_ATTR7 VARCHAR2 (150)
CM_ATTR8 VARCHAR2 (150)
CM_ATTR9 VARCHAR2 (150)
CM_ATTR_CAT VARCHAR2 (30)
CM_CUSTOMER_TRX_ID NUMBER (15) Yes
CM_DEF_USSGL_TRX VARCHAR2 (30)
CM_DEF_USSGL_TRX_CODE_CT VARCHAR2 (30)
CM_DOC_SEQUENCE_ID NUMBER (15)
CM_DOC_SEQUENCE_VALUE NUMBER (15)
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)
LEDGER_ID NUMBER (15)
CM_OPER_UNIT NUMBER (15)
CM_RECEIVABLE_CCID NUMBER

XLA_PARTY_TYPE CHAR (1)
CM_XLA_APPLIED_TO_APP_ID NUMBER

CM_ENTITY_CODE CHAR (12)
CM_PRV_TRX_ID NUMBER (15)
CM_RECEIPT_METHOD_ID NUMBER (15)
Query Text

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
,      LEDGER_ID
,      CM_OPER_UNIT
,      CM_RECEIVABLE_CCID
,      XLA_PARTY_TYPE
,      CM_XLA_APPLIED_TO_APP_ID
,      CM_ENTITY_CODE
,      CM_PRV_TRX_ID
,      CM_RECEIPT_METHOD_ID
FROM APPS.AR_CREDIT_MEMO_H_V;

Dependencies

[top of page]

APPS.AR_CREDIT_MEMO_H_V references the following:

SchemaAPPS
SynonymAR_XLA_LINES_EXTRACT
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUST_TRX_TYPES_ALL
SynonymRA_RULES
SynonymRA_TERRITORIES
APPS.AR_CREDIT_MEMO_H_V is referenced by following:

SchemaAPPS
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