eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_ACCESS_SET_LEDGERS#

Source

View Text - Preformatted


SELECT  /*AUTOREFRESH*/ glasna.access_set_id    AS ACCESS_SET_ID,                DECODE(gllsa.ledger_id,                       NULL, glasna.ledger_id,                       gllsa.ledger_id) AS LEDGER_ID,                DECODE(MIN(DECODE(glasna.all_segment_value_flag,                                  'Y',                                  DECODE(glasna.access_privilege_code,                                         'B', 1, 'R', 3),                                  DECODE(glasna.access_privilege_code,                                         'B', 2, 'R', 3))),                        1, 'F',                        2, 'B',                        3, 'R')                 AS ACCESS_PRIVILEGE_CODE,                MAX(glasna.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE,                0 AS LAST_UPDATED_BY,                MAX(glasna.CREATION_DATE) AS CREATION_DATE,                0 AS CREATED_BY,                0 AS LAST_UPDATE_LOGIN,                TO_DATE(NULL)                   AS START_DATE,                TO_DATE(NULL)                   AS END_DATE        FROM    GL_ACCESS_SETS glas,                GL_ACCESS_SET_NORM_ASSIGN glasna,                GL_LEDGER_SET_ASSIGNMENTS gllsa        WHERE   glas.automatically_created_flag = 'N'        AND     glasna.access_set_id = glas.access_set_id        AND     NVL(glasna.status_code, 'X') <> 'I'        AND     gllsa.ledger_set_id (+) = glasna.ledger_id        GROUP BY glasna.access_set_id,                 DECODE(gllsa.ledger_id, NULL,                        glasna.ledger_id, gllsa.ledger_id)        UNION ALL        Select /*AUTOREFRESH*/ glas.access_set_id AS ACCESS_SET_ID,        DECODE(gll.object_type_code,'S',gllsa.ledger_id,glasna.ledger_id) AS LEDGER_ID,        DECODE(MAX(DECODE(gll.object_type_code,'S',1,DECODE(gllsa.ledger_id,NULL,                                                       DECODE(glasna.all_segment_value_flag,'Y',                                                              DECODE(glasna.access_privilege_code,'R',3,'B',1),                                                              DECODE(glasna.access_privilege_code,'R',3,'B',2)),                                                       DECODE(glasna2.all_segment_value_flag,'Y',                                                              DECODE(glasna2.access_privilege_code,'R',3,'B',1),                                                              DECODE(glasna2.access_privilege_code,'R',3,'B',2))))),                                          1,'F',2,'B',3,'R') AS ACCESS_PRIVILEGE_CODE,    MAX(glasna2.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE,    0 AS LAST_UPDATED_BY,    MAX(glasna2.CREATION_DATE) AS CREATION_DATE,    0 AS CREATED_BY,    0 AS LAST_UPDATE_LOGIN,    TO_DATE(NULL) AS START_DATE,    TO_DATE(NULL) AS END_DATE   FROM   gl_ledgers gll,        gl_access_sets glas,        gl_access_set_norm_assign glasna,        gl_ledger_set_assignments gllsa,        gl_access_set_norm_assign glasna2 WHERE  glas.access_set_id = gll.implicit_access_set_id AND    glas.automatically_created_flag = 'Y' AND    glasna.access_set_id = glas.access_set_id AND    NVL(glasna.status_code,'X') <> 'I' AND    gllsa.ledger_set_id (+) = glasna.ledger_id AND    NVL(gllsa.status_code (+),'X') <> 'I' AND    glasna2.access_set_id = DECODE(gllsa.ledger_set_id , NULL, glasna.access_set_id, glasna.access_set_id) AND    glasna2.ledger_id = DECODE(gll.object_type_code,'S',glasna.ledger_id,NVL(gllsa.ledger_id,glasna.ledger_id)) AND    NVL(glasna2.status_code, 'X') <> 'I' GROUP BY   glas.access_set_id,            DECODE(gll.object_type_code,'S',gllsa.ledger_id,glasna.ledger_id)

View Text - HTML Formatted

SELECT /*AUTOREFRESH*/ GLASNA.ACCESS_SET_ID AS ACCESS_SET_ID
, DECODE(GLLSA.LEDGER_ID
, NULL
, GLASNA.LEDGER_ID
, GLLSA.LEDGER_ID) AS LEDGER_ID
, DECODE(MIN(DECODE(GLASNA.ALL_SEGMENT_VALUE_FLAG
, 'Y'
, DECODE(GLASNA.ACCESS_PRIVILEGE_CODE
, 'B'
, 1
, 'R'
, 3)
, DECODE(GLASNA.ACCESS_PRIVILEGE_CODE
, 'B'
, 2
, 'R'
, 3)))
, 1
, 'F'
, 2
, 'B'
, 3
, 'R') AS ACCESS_PRIVILEGE_CODE
, MAX(GLASNA.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE
, 0 AS LAST_UPDATED_BY
, MAX(GLASNA.CREATION_DATE) AS CREATION_DATE
, 0 AS CREATED_BY
, 0 AS LAST_UPDATE_LOGIN
, TO_DATE(NULL) AS START_DATE
, TO_DATE(NULL) AS END_DATE
FROM GL_ACCESS_SETS GLAS
, GL_ACCESS_SET_NORM_ASSIGN GLASNA
, GL_LEDGER_SET_ASSIGNMENTS GLLSA
WHERE GLAS.AUTOMATICALLY_CREATED_FLAG = 'N'
AND GLASNA.ACCESS_SET_ID = GLAS.ACCESS_SET_ID
AND NVL(GLASNA.STATUS_CODE
, 'X') <> 'I'
AND GLLSA.LEDGER_SET_ID (+) = GLASNA.LEDGER_ID GROUP BY GLASNA.ACCESS_SET_ID
, DECODE(GLLSA.LEDGER_ID
, NULL
, GLASNA.LEDGER_ID
, GLLSA.LEDGER_ID) UNION ALL SELECT /*AUTOREFRESH*/ GLAS.ACCESS_SET_ID AS ACCESS_SET_ID
, DECODE(GLL.OBJECT_TYPE_CODE
, 'S'
, GLLSA.LEDGER_ID
, GLASNA.LEDGER_ID) AS LEDGER_ID
, DECODE(MAX(DECODE(GLL.OBJECT_TYPE_CODE
, 'S'
, 1
, DECODE(GLLSA.LEDGER_ID
, NULL
, DECODE(GLASNA.ALL_SEGMENT_VALUE_FLAG
, 'Y'
, DECODE(GLASNA.ACCESS_PRIVILEGE_CODE
, 'R'
, 3
, 'B'
, 1)
, DECODE(GLASNA.ACCESS_PRIVILEGE_CODE
, 'R'
, 3
, 'B'
, 2))
, DECODE(GLASNA2.ALL_SEGMENT_VALUE_FLAG
, 'Y'
, DECODE(GLASNA2.ACCESS_PRIVILEGE_CODE
, 'R'
, 3
, 'B'
, 1)
, DECODE(GLASNA2.ACCESS_PRIVILEGE_CODE
, 'R'
, 3
, 'B'
, 2)))))
, 1
, 'F'
, 2
, 'B'
, 3
, 'R') AS ACCESS_PRIVILEGE_CODE
, MAX(GLASNA2.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE
, 0 AS LAST_UPDATED_BY
, MAX(GLASNA2.CREATION_DATE) AS CREATION_DATE
, 0 AS CREATED_BY
, 0 AS LAST_UPDATE_LOGIN
, TO_DATE(NULL) AS START_DATE
, TO_DATE(NULL) AS END_DATE
FROM GL_LEDGERS GLL
, GL_ACCESS_SETS GLAS
, GL_ACCESS_SET_NORM_ASSIGN GLASNA
, GL_LEDGER_SET_ASSIGNMENTS GLLSA
, GL_ACCESS_SET_NORM_ASSIGN GLASNA2
WHERE GLAS.ACCESS_SET_ID = GLL.IMPLICIT_ACCESS_SET_ID
AND GLAS.AUTOMATICALLY_CREATED_FLAG = 'Y'
AND GLASNA.ACCESS_SET_ID = GLAS.ACCESS_SET_ID
AND NVL(GLASNA.STATUS_CODE
, 'X') <> 'I'
AND GLLSA.LEDGER_SET_ID (+) = GLASNA.LEDGER_ID
AND NVL(GLLSA.STATUS_CODE (+)
, 'X') <> 'I'
AND GLASNA2.ACCESS_SET_ID = DECODE(GLLSA.LEDGER_SET_ID
, NULL
, GLASNA.ACCESS_SET_ID
, GLASNA.ACCESS_SET_ID)
AND GLASNA2.LEDGER_ID = DECODE(GLL.OBJECT_TYPE_CODE
, 'S'
, GLASNA.LEDGER_ID
, NVL(GLLSA.LEDGER_ID
, GLASNA.LEDGER_ID))
AND NVL(GLASNA2.STATUS_CODE
, 'X') <> 'I' GROUP BY GLAS.ACCESS_SET_ID
, DECODE(GLL.OBJECT_TYPE_CODE
, 'S'
, GLLSA.LEDGER_ID
, GLASNA.LEDGER_ID)