[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_ENTITY_DIFFERENCES |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_ENTITY_DIFFERENCES
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DIFF_ID | NUMBER | Yes | Autogenerated id | |
| DOCUMENT_TYPE | VARCHAR2 | (20) | Yes | Indicates if the document type. Takes values AWARD, IDV |
| ENTITY_NAME | VARCHAR2 | (100) | Yes | This will depict the granular entity for which you are finding the difference. Eg: HEADER/LINE/LINELOCATION |
| MOD_DOC_SOURCE_NAME | VARCHAR2 | (30) | Yes | Table/view name for the changed document |
| COLUMN_NAME | VARCHAR2 | (60) | Yes | Column name |
| MOD_DOC_PK1_VAL | NUMBER | Yes | Primary key of Mod doc | |
| MOD_DOC_PK2_VAL | NUMBER | Primary key of Mod doc | ||
| MOD_DOC_PK3_VAL | NUMBER | Primary key of Mod doc | ||
| MOD_DOC_PK4_VAL | NUMBER | Primary key of Mod doc | ||
| MOD_DOC_PK5_VAL | NUMBER | Primary key of Mod doc | ||
| BASE_DOC_PK1_VAL | NUMBER | Primary key of base doc | ||
| BASE_DOC_PK2_VAL | NUMBER | Primary key of base doc | ||
| BASE_DOC_PK3_VAL | NUMBER | Primary key of base doc | ||
| BASE_DOC_PK4_VAL | NUMBER | Primary key of base doc | ||
| BASE_DOC_PK5_VAL | NUMBER | Primary key of base doc | ||
| MOD_VALUE | VARCHAR2 | (4000) | Value of the column as in the modified document | |
| ORIG_VALUE | VARCHAR2 | (4000) | Value of the column as in base/reference document | |
| MOD_VALUE_DESC | VARCHAR2 | (4000) | If the column in comparison is an id column, then this can hold the description of that value | |
| ORIG_VALUE_DESC | VARCHAR2 | (4000) | If the column in comparison is an id column, then this can hold the description of that value | |
| RUN_ID | NUMBER | Generated by sequence to indicate a specific run. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT DIFF_ID
, DOCUMENT_TYPE
, ENTITY_NAME
, MOD_DOC_SOURCE_NAME
, COLUMN_NAME
, MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL
, MOD_DOC_PK3_VAL
, MOD_DOC_PK4_VAL
, MOD_DOC_PK5_VAL
, BASE_DOC_PK1_VAL
, BASE_DOC_PK2_VAL
, BASE_DOC_PK3_VAL
, BASE_DOC_PK4_VAL
, BASE_DOC_PK5_VAL
, MOD_VALUE
, ORIG_VALUE
, MOD_VALUE_DESC
, ORIG_VALUE_DESC
, RUN_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM PO.PO_ENTITY_DIFFERENCES;
PO.PO_ENTITY_DIFFERENCES does not reference any database object
PO.PO_ENTITY_DIFFERENCES is referenced by following:
PO
PO_ENTITY_DIFFERENCES#
|
|
|
|