FV_BE_LEVEL_OPERATIONS_V

Details

• Schema: FUSION

• Object owner: FV

• Object type: VIEW

Columns

Name
BUDGET_LEVEL_ID BUDGET_LEVEL LEDGER_ID BUDGET_LEVEL_SEQ_NUM LEVEL_NUM OPERATION_CODE ALL_ALLOWED VIEW_ALLOWED APPROVE_CANCEL_ALLOWED CRUD_ALLOWED REVISE_ALLOWED

Query

SQL_Statement

SELECT BUDGET_LEVEL_ID, BUDGET_LEVEL, LEDGER_ID, BUDGET_LEVEL_SEQ_NUM, LEVEL_NUM, OPERATION.OP OPERATION_CODE, DECODE(INSTR(NVL(OPERATION.OP,0),'ALL'),0,'N','Y') ALL_ALLOWED, DECODE(INSTR(NVL(OPERATION.OP,0),'V'),0,'N','Y') VIEW_ALLOWED, DECODE(SUBSTR(NVL(OPERATION.OP,0),'2','1'),'A','Y','N') APPROVE_CANCEL_ALLOWED, DECODE(INSTR(NVL(OPERATION.OP,0),'C'),0,'N','Y') CRUD_ALLOWED, DECODE(INSTR(NVL(OPERATION.OP,0),'R'),0,'N','Y') REVISE_ALLOWED FROM FV_BE_LEVELS, (SELECT LOOKUP_CODE OP,MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='ORA_FV_BE_LEVEL_OPERATION') OPERATION