[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:
|
|
|