[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CHANGE_MATRIX# |
|---|---|
| Object Type: | VIEW |
| Owner: | AR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHANGE_MATRIX_ID | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ACTION | VARCHAR2 | (1) | Yes | |
| CHECK_IN_INSERT_MODE_FLAG | VARCHAR2 | (1) | ||
| FORM | VARCHAR2 | (30) | Yes | |
| ZONE | VARCHAR2 | (30) | ||
| FIELD | VARCHAR2 | (30) | ||
| APPLICATION_ID | NUMBER | (15) | ||
| TRANSACTION_TYPE | VARCHAR2 | (20) | ||
| ACCOUNTING_RULE_TYPE | VARCHAR2 | (10) | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| PROHIBIT_ALL_CHANGES_FLAG | VARCHAR2 | (1) | ||
| CHANGE_COMPLETE_FLAG | VARCHAR2 | (1) | ||
| CHANGE_RULES_FLAG | VARCHAR2 | (1) | ||
| CHANGE_PRINTED_FLAG | VARCHAR2 | (1) | ||
| CHANGE_ACTIVITY_FLAG | VARCHAR2 | (1) | ||
| CHANGE_POSTED_FLAG | VARCHAR2 | (1) | ||
| CHANGE_AUTORULE_FLAG | VARCHAR2 | (1) | ||
| CHANGE_REV_BASED_ON_SREP_FLAG | VARCHAR2 | (1) | ||
| CHANGE_CHANGE_CUST_ON_TRX_FLAG | VARCHAR2 | (1) | ||
| CHG_CHANGE_PRINTED_INV_FLAG | VARCHAR2 | (1) | ||
| CHANGE_TAX_UPDATE_FLAG | VARCHAR2 | (1) | ||
| CHG_USE_INV_ACCT_FOR_CM_FLAG | VARCHAR2 | (1) | ||
| CHANGE_INVOICE_DELETION_FLAG | VARCHAR2 | (1) | ||
| CHANGE_AR_UPDATE_DUE_DATE_FLAG | VARCHAR2 | (1) | ||
| CHANGE_CHANGE_CUST_NAME_FLAG | VARCHAR2 | (1) | ||
| COMPLETE_MESSAGE_NAME | VARCHAR2 | (30) | ||
| RULES_MESSAGE_NAME | VARCHAR2 | (30) | ||
| PRINTED_MESSAGE_NAME | VARCHAR2 | (30) | ||
| ACTIVITY_MESSAGE_NAME | VARCHAR2 | (30) | ||
| POSTED_MESSAGE_NAME | VARCHAR2 | (30) | ||
| AUTORULE_MESSAGE_NAME | VARCHAR2 | (30) | ||
| CHANGE_CUST_ON_TRX_MSG_NAME | VARCHAR2 | (30) | ||
| CHANGES_AFTER_PRINT_MSG_NAME | VARCHAR2 | (30) | ||
| TAX_UPDATE_MESSAGE_NAME | VARCHAR2 | (30) | ||
| USE_INV_ACCT_FOR_CM_MSG_NAME | VARCHAR2 | (30) | ||
| INVOICE_DELETION_MESSAGE_NAME | VARCHAR2 | (30) | ||
| AR_UPDATE_DUE_DATE_MSG_NAME | VARCHAR2 | (30) | ||
| CHANGE_CUST_NAME_MESSAGE_NAME | VARCHAR2 | (30) | ||
| REV_BASED_ON_SREP_MSG_NAME | VARCHAR2 | (30) | ||
| PROHIBIT_ALL_CHANGES_MSG_NAME | VARCHAR2 | (30) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| CHANGE_UNCONFIRMED_INV_FLAG | VARCHAR2 | (1) | ||
| CHANGE_UNCONF_INV_MSG_NAME | VARCHAR2 | (30) | ||
| BATCH_SOURCE_TYPE | VARCHAR2 | (30) | ||
| CHANGE_AUTOTAX_FLAG | VARCHAR2 | (1) | ||
| AUTOTAX_MSG_NAME | VARCHAR2 | (30) | ||
| ACCOUNTING_METHOD | VARCHAR2 | (30) | ||
| CREATED_FROM | VARCHAR2 | (30) | ||
| CANVAS | VARCHAR2 | (30) | ||
| CANVAS_TO_CHANGE | VARCHAR2 | (30) | ||
| CHANGE_USSGL_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION1_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION2_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION3_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION4_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION5_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION6_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION7_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION8_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION9_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION10_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION11_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION12_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION13_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION14_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION15_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION16_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION17_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION18_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION19_FLAG | VARCHAR2 | (1) | ||
| CHANGE_FUNCTION20_FLAG | VARCHAR2 | (1) | ||
| USSGL_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION1_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION2_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION3_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION4_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION5_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION6_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION7_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION8_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION9_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION10_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION11_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION12_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION13_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION14_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION15_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION16_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION17_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION18_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION19_MSG_NAME | VARCHAR2 | (30) | ||
| FUNCTION20_MSG_NAME | VARCHAR2 | (30) | ||
| COMPLETE_PROPERTY | VARCHAR2 | (20) | ||
| RULES_PROPERTY | VARCHAR2 | (20) | ||
| PRINTED_PROPERTY | VARCHAR2 | (20) | ||
| ACTIVITY_PROPERTY | VARCHAR2 | (20) | ||
| POSTED_PROPERTY | VARCHAR2 | (20) | ||
| AUTORULE_PROPERTY | VARCHAR2 | (20) | ||
| CHANGE_CUST_ON_TRX_PROPERTY | VARCHAR2 | (20) | ||
| CHANGES_AFTER_PRINT_PROPERTY | VARCHAR2 | (20) | ||
| TAX_UPDATE_PROPERTY | VARCHAR2 | (20) | ||
| USE_INV_ACCT_FOR_CM_PROPERTY | VARCHAR2 | (20) | ||
| INVOICE_DELETION_PROPERTY | VARCHAR2 | (20) | ||
| AR_UPDATE_DUE_DATE_PROPERTY | VARCHAR2 | (20) | ||
| CHANGE_CUST_NAME_PROPERTY | VARCHAR2 | (20) | ||
| REV_BASED_ON_SREP_PROPERTY | VARCHAR2 | (20) | ||
| PROHIBIT_ALL_CHANGES_PROPERTY | VARCHAR2 | (20) | ||
| CHANGE_UNCONF_INV_PROPERTY | VARCHAR2 | (20) | ||
| USSGL_PROPERTY | VARCHAR2 | (20) | ||
| AUTOTAX_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION1_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION2_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION3_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION4_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION5_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION6_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION7_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION8_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION9_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION10_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION11_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION12_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION13_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION14_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION15_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION16_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION17_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION18_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION19_PROPERTY | VARCHAR2 | (20) | ||
| FUNCTION20_PROPERTY | VARCHAR2 | (20) | ||
| FIELD_MIRROR | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_MATRIX_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ACTION
, CHECK_IN_INSERT_MODE_FLAG
, FORM
, ZONE
, FIELD
, APPLICATION_ID
, TRANSACTION_TYPE
, ACCOUNTING_RULE_TYPE
, EXCHANGE_RATE_TYPE
, PROHIBIT_ALL_CHANGES_FLAG
, CHANGE_COMPLETE_FLAG
, CHANGE_RULES_FLAG
, CHANGE_PRINTED_FLAG
, CHANGE_ACTIVITY_FLAG
, CHANGE_POSTED_FLAG
, CHANGE_AUTORULE_FLAG
, CHANGE_REV_BASED_ON_SREP_FLAG
, CHANGE_CHANGE_CUST_ON_TRX_FLAG
, CHG_CHANGE_PRINTED_INV_FLAG
, CHANGE_TAX_UPDATE_FLAG
, CHG_USE_INV_ACCT_FOR_CM_FLAG
, CHANGE_INVOICE_DELETION_FLAG
, CHANGE_AR_UPDATE_DUE_DATE_FLAG
, CHANGE_CHANGE_CUST_NAME_FLAG
, COMPLETE_MESSAGE_NAME
, RULES_MESSAGE_NAME
, PRINTED_MESSAGE_NAME
, ACTIVITY_MESSAGE_NAME
, POSTED_MESSAGE_NAME
, AUTORULE_MESSAGE_NAME
, CHANGE_CUST_ON_TRX_MSG_NAME
, CHANGES_AFTER_PRINT_MSG_NAME
, TAX_UPDATE_MESSAGE_NAME
, USE_INV_ACCT_FOR_CM_MSG_NAME
, INVOICE_DELETION_MESSAGE_NAME
, AR_UPDATE_DUE_DATE_MSG_NAME
, CHANGE_CUST_NAME_MESSAGE_NAME
, REV_BASED_ON_SREP_MSG_NAME
, PROHIBIT_ALL_CHANGES_MSG_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CHANGE_UNCONFIRMED_INV_FLAG
, CHANGE_UNCONF_INV_MSG_NAME
, BATCH_SOURCE_TYPE
, CHANGE_AUTOTAX_FLAG
, AUTOTAX_MSG_NAME
, ACCOUNTING_METHOD
, CREATED_FROM
, CANVAS
, CANVAS_TO_CHANGE
, CHANGE_USSGL_FLAG
, CHANGE_FUNCTION1_FLAG
, CHANGE_FUNCTION2_FLAG
, CHANGE_FUNCTION3_FLAG
, CHANGE_FUNCTION4_FLAG
, CHANGE_FUNCTION5_FLAG
, CHANGE_FUNCTION6_FLAG
, CHANGE_FUNCTION7_FLAG
, CHANGE_FUNCTION8_FLAG
, CHANGE_FUNCTION9_FLAG
, CHANGE_FUNCTION10_FLAG
, CHANGE_FUNCTION11_FLAG
, CHANGE_FUNCTION12_FLAG
, CHANGE_FUNCTION13_FLAG
, CHANGE_FUNCTION14_FLAG
, CHANGE_FUNCTION15_FLAG
, CHANGE_FUNCTION16_FLAG
, CHANGE_FUNCTION17_FLAG
, CHANGE_FUNCTION18_FLAG
, CHANGE_FUNCTION19_FLAG
, CHANGE_FUNCTION20_FLAG
, USSGL_MSG_NAME
, FUNCTION1_MSG_NAME
, FUNCTION2_MSG_NAME
, FUNCTION3_MSG_NAME
, FUNCTION4_MSG_NAME
, FUNCTION5_MSG_NAME
, FUNCTION6_MSG_NAME
, FUNCTION7_MSG_NAME
, FUNCTION8_MSG_NAME
, FUNCTION9_MSG_NAME
, FUNCTION10_MSG_NAME
, FUNCTION11_MSG_NAME
, FUNCTION12_MSG_NAME
, FUNCTION13_MSG_NAME
, FUNCTION14_MSG_NAME
, FUNCTION15_MSG_NAME
, FUNCTION16_MSG_NAME
, FUNCTION17_MSG_NAME
, FUNCTION18_MSG_NAME
, FUNCTION19_MSG_NAME
, FUNCTION20_MSG_NAME
, COMPLETE_PROPERTY
, RULES_PROPERTY
, PRINTED_PROPERTY
, ACTIVITY_PROPERTY
, POSTED_PROPERTY
, AUTORULE_PROPERTY
, CHANGE_CUST_ON_TRX_PROPERTY
, CHANGES_AFTER_PRINT_PROPERTY
, TAX_UPDATE_PROPERTY
, USE_INV_ACCT_FOR_CM_PROPERTY
, INVOICE_DELETION_PROPERTY
, AR_UPDATE_DUE_DATE_PROPERTY
, CHANGE_CUST_NAME_PROPERTY
, REV_BASED_ON_SREP_PROPERTY
, PROHIBIT_ALL_CHANGES_PROPERTY
, CHANGE_UNCONF_INV_PROPERTY
, USSGL_PROPERTY
, AUTOTAX_PROPERTY
, FUNCTION1_PROPERTY
, FUNCTION2_PROPERTY
, FUNCTION3_PROPERTY
, FUNCTION4_PROPERTY
, FUNCTION5_PROPERTY
, FUNCTION6_PROPERTY
, FUNCTION7_PROPERTY
, FUNCTION8_PROPERTY
, FUNCTION9_PROPERTY
, FUNCTION10_PROPERTY
, FUNCTION11_PROPERTY
, FUNCTION12_PROPERTY
, FUNCTION13_PROPERTY
, FUNCTION14_PROPERTY
, FUNCTION15_PROPERTY
, FUNCTION16_PROPERTY
, FUNCTION17_PROPERTY
, FUNCTION18_PROPERTY
, FUNCTION19_PROPERTY
, FUNCTION20_PROPERTY
, FIELD_MIRROR
FROM AR.AR_CHANGE_MATRIX#;
AR
AR_CHANGE_MATRIX
APPS
AR_CHANGE_MATRIX
|
|
|
|