FND_TREE_VERSION_AUDIT_RES

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID REQUESTID AUDIT_RESULT_ID TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID VALIDATOR_CODE VALIDATION_PASS CORRECTIVE_ACTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION VALIDATOR_NAME VALIDATION_MESSAGE CORRECTION_UI DETAIL_MESSAGE

Name

ROW_ID

REQUESTID

AUDIT_RESULT_ID

TREE_STRUCTURE_CODE

TREE_CODE

TREE_VERSION_ID

VALIDATOR_CODE

VALIDATION_PASS

CORRECTIVE_ACTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DESCRIPTION

VALIDATOR_NAME

VALIDATION_MESSAGE

CORRECTION_UI

DETAIL_MESSAGE

Query

SQL_Statement
SELECT FND_TREE_VERSION_AUDIT_RES.ROWID ROW_ID, FND_TREE_VERSION_AUDIT_RES.REQUESTID REQUESTID, FND_TREE_VERSION_AUDIT_RES.AUDIT_RESULT_ID AUDIT_RESULT_ID, FND_TREE_VERSION_AUDIT_RES.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE, FND_TREE_VERSION_AUDIT_RES.TREE_CODE TREE_CODE, FND_TREE_VERSION_AUDIT_RES.TREE_VERSION_ID TREE_VERSION_ID, FND_TREE_VERSION_AUDIT_RES.VALIDATOR_CODE VALIDATOR_CODE, FND_TREE_VERSION_AUDIT_RES.VALIDATION_PASS VALIDATION_PASS, FND_TREE_VERSION_AUDIT_RES.CORRECTIVE_ACTION CORRECTIVE_ACTION, FND_TREE_VERSION_AUDIT_RES.CREATED_BY CREATED_BY, FND_TREE_VERSION_AUDIT_RES.CREATION_DATE CREATION_DATE, FND_TREE_VERSION_AUDIT_RES.LAST_UPDATED_BY LAST_UPDATED_BY, FND_TREE_VERSION_AUDIT_RES.LAST_UPDATE_DATE LAST_UPDATE_DATE, FND_TREE_VERSION_AUDIT_RES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FND_TREE_VERSION_AUDIT_RES_TL.DESCRIPTION DESCRIPTION, FND_TREE_VERSION_AUDIT_RES_TL.VALIDATOR_NAME VALIDATOR_NAME, FND_TREE_VERSION_AUDIT_RES_TL.VALIDATION_MESSAGE VALIDATION_MESSAGE, FND_TREE_VERSION_AUDIT_RES_TL.CORRECTION_UI CORRECTION_UI, FND_TREE_VERSION_AUDIT_RES.DETAIL_MESSAGE DETAIL_MESSAGE FROM FND_TREE_VERSION_AUDIT_RES, FND_TREE_VERSION_AUDIT_RES_TL WHERE FND_TREE_VERSION_AUDIT_RES.REQUESTID = FND_TREE_VERSION_AUDIT_RES_TL.REQUESTID AND FND_TREE_VERSION_AUDIT_RES.AUDIT_RESULT_ID = FND_TREE_VERSION_AUDIT_RES_TL.AUDIT_RESULT_ID AND FND_TREE_VERSION_AUDIT_RES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

FND_TREE_VERSION_AUDIT_RES.ROWID ROW_ID,

FND_TREE_VERSION_AUDIT_RES.REQUESTID REQUESTID,

FND_TREE_VERSION_AUDIT_RES.AUDIT_RESULT_ID AUDIT_RESULT_ID,

FND_TREE_VERSION_AUDIT_RES.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE,

FND_TREE_VERSION_AUDIT_RES.TREE_CODE TREE_CODE,

FND_TREE_VERSION_AUDIT_RES.TREE_VERSION_ID TREE_VERSION_ID,

FND_TREE_VERSION_AUDIT_RES.VALIDATOR_CODE VALIDATOR_CODE,

FND_TREE_VERSION_AUDIT_RES.VALIDATION_PASS VALIDATION_PASS,

FND_TREE_VERSION_AUDIT_RES.CORRECTIVE_ACTION CORRECTIVE_ACTION,

FND_TREE_VERSION_AUDIT_RES.CREATED_BY CREATED_BY,

FND_TREE_VERSION_AUDIT_RES.CREATION_DATE CREATION_DATE,

FND_TREE_VERSION_AUDIT_RES.LAST_UPDATED_BY LAST_UPDATED_BY,

FND_TREE_VERSION_AUDIT_RES.LAST_UPDATE_DATE LAST_UPDATE_DATE,

FND_TREE_VERSION_AUDIT_RES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

FND_TREE_VERSION_AUDIT_RES_TL.DESCRIPTION DESCRIPTION,

FND_TREE_VERSION_AUDIT_RES_TL.VALIDATOR_NAME VALIDATOR_NAME,

FND_TREE_VERSION_AUDIT_RES_TL.VALIDATION_MESSAGE VALIDATION_MESSAGE,

FND_TREE_VERSION_AUDIT_RES_TL.CORRECTION_UI CORRECTION_UI,

FND_TREE_VERSION_AUDIT_RES.DETAIL_MESSAGE DETAIL_MESSAGE

FROM

FND_TREE_VERSION_AUDIT_RES,

FND_TREE_VERSION_AUDIT_RES_TL

WHERE

FND_TREE_VERSION_AUDIT_RES.REQUESTID = FND_TREE_VERSION_AUDIT_RES_TL.REQUESTID AND FND_TREE_VERSION_AUDIT_RES.AUDIT_RESULT_ID = FND_TREE_VERSION_AUDIT_RES_TL.AUDIT_RESULT_ID AND FND_TREE_VERSION_AUDIT_RES_TL.LANGUAGE = USERENV('LANG')