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


TABLE: AR.AR_CHANGE_MATRIX

Object Details
Object Name: AR_CHANGE_MATRIX
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_CHANGE_MATRIX
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CHANGE_MATRIX_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGE_MATRIX_ID
AR_CHANGE_MATRIX_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORM
ColumnZONE
ColumnFIELD
Columns
Name Datatype Length Mandatory Comments
CHANGE_MATRIX_ID NUMBER (15) Yes Unique identifier for ar_change_matrix
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ACTION VARCHAR2 (1) Yes Action this record is for; can be I (insert), U (update), D (delete)
CHECK_IN_INSERT_MODE_FLAG VARCHAR2 (1)
Y or N flag if permission checking should be done in insert mode
FORM VARCHAR2 (30) Yes Form name
ZONE VARCHAR2 (30)
Zone name
FIELD VARCHAR2 (30)
Field name
APPLICATION_ID NUMBER (15)
Application identifier
TRANSACTION_TYPE VARCHAR2 (20)
Lookup code for INV/CM
ACCOUNTING_RULE_TYPE VARCHAR2 (10)
Lookup code for RULE_TYPE
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type
PROHIBIT_ALL_CHANGES_FLAG VARCHAR2 (1)
Y or N flag indicates whether all changes are prohibited
CHANGE_COMPLETE_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made when the transaction is incomplete
CHANGE_RULES_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made if the transaction uses invoicing rules
CHANGE_PRINTED_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made after printing
CHANGE_ACTIVITY_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made after activity has occurred
CHANGE_POSTED_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made after the transaction has been posted
CHANGE_AUTORULE_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made after AutoRule has been run for this transaction
CHANGE_REV_BASED_ON_SREP_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made when the CHANGE_CUST_ON_TRX option is set
CHANGE_CHANGE_CUST_ON_TRX_FLAG VARCHAR2 (1)
Y or N flag indicates whether changes can be made when the CHANGE_CUST_ON_TRX option has been set
CHG_CHANGE_PRINTED_INV_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made after the transaction has been printed.
CHANGE_TAX_UPDATE_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the TAX_UPDATE_FLAG is set.
CHG_USE_INV_ACCT_FOR_CM_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the USE_INV_ACCT_FOR_CM_FLAG option has been set.
CHANGE_INVOICE_DELETION_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the INVOICE_DELETION_FLAG has been set.
CHANGE_AR_UPDATE_DUE_DATE_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the AR_UPDATE_DUE_DATE_FLAG has been set.
CHANGE_CHANGE_CUST_NAME_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the CHANGE_CUST_NAME_FLAG has been set.
COMPLETE_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the complete constraint is violated.
RULES_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the rules constraint is violated.
PRINTED_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the printed constraint is violated.
ACTIVITY_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the activity constraint is violated.
POSTED_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the posted constraint is violated.
AUTORULE_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the AutoRule constraint is violated.
CHANGE_CUST_ON_TRX_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the CHANGE_CUST_ON_TRX constraint is violated.
CHANGES_AFTER_PRINT_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the CHANGES_AFTER_PRINTING constraint is violated.
TAX_UPDATE_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the TAX_UPDATE constraint is violated.
USE_INV_ACCT_FOR_CM_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the USE_INV_ACCT_FOR_CM constraint is violated.
INVOICE_DELETION_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the INVOICE_DELETION constraint is violated.
AR_UPDATE_DUE_DATE_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the AR_UPDATE_DUE_DATE constraint is violated.
CHANGE_CUST_NAME_MESSAGE_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the CHANGE_CUST_NAME constraint is violated.
REV_BASED_ON_SREP_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the REV_BASED_ON_SREP constraint is violated.
PROHIBIT_ALL_CHANGES_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the PROHIBIT_ALL_CHANGES constraint is violated.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CHANGE_UNCONFIRMED_INV_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the CHANGE_UNCONFIRMED_INV_FLAG has been set.
CHANGE_UNCONF_INV_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the CHANGE_CUST_NAME_FLAG constraint has been violated.
BATCH_SOURCE_TYPE VARCHAR2 (30)
Foreign key to ra_batch_Sources.batch_source_type. Imported if the batch source is used by AutoInvoice; Manual otherwise
CHANGE_AUTOTAX_FLAG VARCHAR2 (1)
Yes/No flag if changes can be made when the CHANGE_AUTOTAX_FLAG has been set.
AUTOTAX_MSG_NAME VARCHAR2 (30)
Message dictionary message name that is displayed when the AutoTax constraint has been violated.
ACCOUNTING_METHOD VARCHAR2 (30)
The accounting method that is being used. May be CASH or ACCRUAL.
CREATED_FROM VARCHAR2 (30)
Short name of the form to which this constraint applies.
CANVAS VARCHAR2 (30)
For internal use only
CANVAS_TO_CHANGE VARCHAR2 (30)
For internal use only
CHANGE_USSGL_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION1_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION2_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION3_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION4_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION5_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION6_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION7_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION8_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION9_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION10_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION11_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION12_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION13_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION14_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION15_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION16_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION17_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION18_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION19_FLAG VARCHAR2 (1)
For internal use only
CHANGE_FUNCTION20_FLAG VARCHAR2 (1)
For internal use only
USSGL_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION1_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION2_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION3_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION4_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION5_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION6_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION7_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION8_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION9_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION10_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION11_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION12_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION13_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION14_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION15_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION16_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION17_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION18_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION19_MSG_NAME VARCHAR2 (30)
For internal use only
FUNCTION20_MSG_NAME VARCHAR2 (30)
For internal use only
COMPLETE_PROPERTY VARCHAR2 (20)
For internal use only
RULES_PROPERTY VARCHAR2 (20)
For internal use only
PRINTED_PROPERTY VARCHAR2 (20)
For internal use only
ACTIVITY_PROPERTY VARCHAR2 (20)
For internal use only
POSTED_PROPERTY VARCHAR2 (20)
For internal use only
AUTORULE_PROPERTY VARCHAR2 (20)
For internal use only
CHANGE_CUST_ON_TRX_PROPERTY VARCHAR2 (20)
For internal use only
CHANGES_AFTER_PRINT_PROPERTY VARCHAR2 (20)
For internal use only
TAX_UPDATE_PROPERTY VARCHAR2 (20)
For internal use only
USE_INV_ACCT_FOR_CM_PROPERTY VARCHAR2 (20)
For internal use only
INVOICE_DELETION_PROPERTY VARCHAR2 (20)
For internal use only
AR_UPDATE_DUE_DATE_PROPERTY VARCHAR2 (20)
For internal use only
CHANGE_CUST_NAME_PROPERTY VARCHAR2 (20)
For internal use only
REV_BASED_ON_SREP_PROPERTY VARCHAR2 (20)
For internal use only
PROHIBIT_ALL_CHANGES_PROPERTY VARCHAR2 (20)
For internal use only
CHANGE_UNCONF_INV_PROPERTY VARCHAR2 (20)
For internal use only
USSGL_PROPERTY VARCHAR2 (20)
For internal use only
AUTOTAX_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION1_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION2_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION3_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION4_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION5_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION6_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION7_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION8_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION9_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION10_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION11_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION12_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION13_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION14_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION15_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION16_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION17_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION18_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION19_PROPERTY VARCHAR2 (20)
For internal use only
FUNCTION20_PROPERTY VARCHAR2 (20)
For internal use only
FIELD_MIRROR VARCHAR2 (30)
For internal use only
Query Text

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;

Dependencies

[top of page]

AR.AR_CHANGE_MATRIX does not reference any database object

AR.AR_CHANGE_MATRIX is referenced by following:

SchemaAR
ViewAR_CHANGE_MATRIX#