CMF_FISCAL_DOC_HOLDS

Details

Schema: FUSION
Object owner: CMF
Object type: VIEW

Columns

Name
FISCAL_DOC_HOLD_ID OBJECT_VERSION_NUMBER DOCUMENT_HEADER_ID DOCUMENT_LINE_ID FISCAL_DOC_SCHEDULE_ID TOLERANCE_RULE_ID HOLD_CODE EXCEPTION_TYPE_CODE HELD_BY RELEASE_REASON_CODE RELEASE_TYPE RELEASED_BY RELEASE_DATE PROCESSOR_NAME RUN_CONTROL MESSAGE_NAME MESSAGE_TYPE TOKEN1_NAME TOKEN1_VALUE TOKEN2_NAME TOKEN2_VALUE TOKEN3_NAME TOKEN3_VALUE TOKEN4_NAME TOKEN4_VALUE TOKEN5_NAME TOKEN5_VALUE TOKEN6_NAME TOKEN6_VALUE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE HOLD_REASON RELEASE_REASON

Name

FISCAL_DOC_HOLD_ID

OBJECT_VERSION_NUMBER

DOCUMENT_HEADER_ID

DOCUMENT_LINE_ID

FISCAL_DOC_SCHEDULE_ID

TOLERANCE_RULE_ID

HOLD_CODE

EXCEPTION_TYPE_CODE

HELD_BY

RELEASE_REASON_CODE

RELEASE_TYPE

RELEASED_BY

RELEASE_DATE

PROCESSOR_NAME

RUN_CONTROL

MESSAGE_NAME

MESSAGE_TYPE

TOKEN1_NAME

TOKEN1_VALUE

TOKEN2_NAME

TOKEN2_VALUE

TOKEN3_NAME

TOKEN3_VALUE

TOKEN4_NAME

TOKEN4_VALUE

TOKEN5_NAME

TOKEN5_VALUE

TOKEN6_NAME

TOKEN6_VALUE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

HOLD_REASON

RELEASE_REASON

Query

SQL_Statement
SELECT CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_HOLD_ID FISCAL_DOC_HOLD_ID, CMF_FISCAL_DOC_HOLDS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMF_FISCAL_DOC_HOLDS_B.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, CMF_FISCAL_DOC_HOLDS_B.DOCUMENT_LINE_ID DOCUMENT_LINE_ID, CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_SCHEDULE_ID FISCAL_DOC_SCHEDULE_ID, CMF_FISCAL_DOC_HOLDS_B.TOLERANCE_RULE_ID TOLERANCE_RULE_ID, CMF_FISCAL_DOC_HOLDS_B.HOLD_CODE HOLD_CODE, CMF_FISCAL_DOC_HOLDS_B.EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE, CMF_FISCAL_DOC_HOLDS_B.HELD_BY HELD_BY, CMF_FISCAL_DOC_HOLDS_B.RELEASE_REASON_CODE RELEASE_REASON_CODE, CMF_FISCAL_DOC_HOLDS_B.RELEASE_TYPE RELEASE_TYPE, CMF_FISCAL_DOC_HOLDS_B.RELEASED_BY RELEASED_BY, CMF_FISCAL_DOC_HOLDS_B.RELEASE_DATE RELEASE_DATE, CMF_FISCAL_DOC_HOLDS_B.PROCESSOR_NAME PROCESSOR_NAME, CMF_FISCAL_DOC_HOLDS_B.RUN_CONTROL RUN_CONTROL, CMF_FISCAL_DOC_HOLDS_B.MESSAGE_NAME MESSAGE_NAME, CMF_FISCAL_DOC_HOLDS_B.MESSAGE_TYPE MESSAGE_TYPE, CMF_FISCAL_DOC_HOLDS_B.TOKEN1_NAME TOKEN1_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN1_VALUE TOKEN1_VALUE, CMF_FISCAL_DOC_HOLDS_B.TOKEN2_NAME TOKEN2_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN2_VALUE TOKEN2_VALUE, CMF_FISCAL_DOC_HOLDS_B.TOKEN3_NAME TOKEN3_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN3_VALUE TOKEN3_VALUE, CMF_FISCAL_DOC_HOLDS_B.TOKEN4_NAME TOKEN4_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN4_VALUE TOKEN4_VALUE, CMF_FISCAL_DOC_HOLDS_B.TOKEN5_NAME TOKEN5_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN5_VALUE TOKEN5_VALUE, CMF_FISCAL_DOC_HOLDS_B.TOKEN6_NAME TOKEN6_NAME, CMF_FISCAL_DOC_HOLDS_B.TOKEN6_VALUE TOKEN6_VALUE, CMF_FISCAL_DOC_HOLDS_B.CREATED_BY CREATED_BY, CMF_FISCAL_DOC_HOLDS_B.CREATION_DATE CREATION_DATE, CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMF_FISCAL_DOC_HOLDS_B.REQUEST_ID REQUEST_ID, CMF_FISCAL_DOC_HOLDS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, CMF_FISCAL_DOC_HOLDS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, CMF_FISCAL_DOC_HOLDS_TL.HOLD_REASON HOLD_REASON, CMF_FISCAL_DOC_HOLDS_TL.RELEASE_REASON RELEASE_REASON FROM CMF_FISCAL_DOC_HOLDS_B CMF_FISCAL_DOC_HOLDS_B, CMF_FISCAL_DOC_HOLDS_TL CMF_FISCAL_DOC_HOLDS_TL WHERE CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_HOLD_ID = CMF_FISCAL_DOC_HOLDS_TL.FISCAL_DOC_HOLD_ID AND CMF_FISCAL_DOC_HOLDS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_HOLD_ID FISCAL_DOC_HOLD_ID,

CMF_FISCAL_DOC_HOLDS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CMF_FISCAL_DOC_HOLDS_B.DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID,

CMF_FISCAL_DOC_HOLDS_B.DOCUMENT_LINE_ID DOCUMENT_LINE_ID,

CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_SCHEDULE_ID FISCAL_DOC_SCHEDULE_ID,

CMF_FISCAL_DOC_HOLDS_B.TOLERANCE_RULE_ID TOLERANCE_RULE_ID,

CMF_FISCAL_DOC_HOLDS_B.HOLD_CODE HOLD_CODE,

CMF_FISCAL_DOC_HOLDS_B.EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE,

CMF_FISCAL_DOC_HOLDS_B.HELD_BY HELD_BY,

CMF_FISCAL_DOC_HOLDS_B.RELEASE_REASON_CODE RELEASE_REASON_CODE,

CMF_FISCAL_DOC_HOLDS_B.RELEASE_TYPE RELEASE_TYPE,

CMF_FISCAL_DOC_HOLDS_B.RELEASED_BY RELEASED_BY,

CMF_FISCAL_DOC_HOLDS_B.RELEASE_DATE RELEASE_DATE,

CMF_FISCAL_DOC_HOLDS_B.PROCESSOR_NAME PROCESSOR_NAME,

CMF_FISCAL_DOC_HOLDS_B.RUN_CONTROL RUN_CONTROL,

CMF_FISCAL_DOC_HOLDS_B.MESSAGE_NAME MESSAGE_NAME,

CMF_FISCAL_DOC_HOLDS_B.MESSAGE_TYPE MESSAGE_TYPE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN1_NAME TOKEN1_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN1_VALUE TOKEN1_VALUE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN2_NAME TOKEN2_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN2_VALUE TOKEN2_VALUE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN3_NAME TOKEN3_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN3_VALUE TOKEN3_VALUE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN4_NAME TOKEN4_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN4_VALUE TOKEN4_VALUE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN5_NAME TOKEN5_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN5_VALUE TOKEN5_VALUE,

CMF_FISCAL_DOC_HOLDS_B.TOKEN6_NAME TOKEN6_NAME,

CMF_FISCAL_DOC_HOLDS_B.TOKEN6_VALUE TOKEN6_VALUE,

CMF_FISCAL_DOC_HOLDS_B.CREATED_BY CREATED_BY,

CMF_FISCAL_DOC_HOLDS_B.CREATION_DATE CREATION_DATE,

CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CMF_FISCAL_DOC_HOLDS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CMF_FISCAL_DOC_HOLDS_B.REQUEST_ID REQUEST_ID,

CMF_FISCAL_DOC_HOLDS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

CMF_FISCAL_DOC_HOLDS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

CMF_FISCAL_DOC_HOLDS_TL.HOLD_REASON HOLD_REASON,

CMF_FISCAL_DOC_HOLDS_TL.RELEASE_REASON RELEASE_REASON

FROM

CMF_FISCAL_DOC_HOLDS_B CMF_FISCAL_DOC_HOLDS_B,

CMF_FISCAL_DOC_HOLDS_TL CMF_FISCAL_DOC_HOLDS_TL

WHERE

CMF_FISCAL_DOC_HOLDS_B.FISCAL_DOC_HOLD_ID = CMF_FISCAL_DOC_HOLDS_TL.FISCAL_DOC_HOLD_ID AND CMF_FISCAL_DOC_HOLDS_TL.LANGUAGE = USERENV('LANG')