$PROFILES$.XLA_MO_TOP_REPORTING_LEVEL
Hi,
In one of the concurrent programs I am using , it uses a value set
XLA_MO_REPORTING_LEVEL(Table type value set)
which has the following
where clause
Where/ Order By WHERE
lookup_type = 'XLA_MO_REPORTING_LEVEL'
AND ((TO_NUMBER(lookup_code) >=
TO_NUMBER(:$PROFILES$.XLA_MO_TOP_REPORTING_LEVEL)
AND NVL(pg.multi_org_flag,'N')='Y')
OR (lookup_code = '1000'
AND NVL(pg.multi_org_flag,'N')='N'))
ORDER BY TO_NUMBER(lookup_code)
Whenever I am trying to find the value of $PROFILES$.XLA_MO_TOP_REPORTING_LEVEL via Help-->EXAMINE
I am getting an error message stating that it is an invalid reference.
In one of the concurrent programs I am using , it uses a value set
XLA_MO_REPORTING_LEVEL(Table type value set)
which has the following
where clause
Where/ Order By WHERE
lookup_type = 'XLA_MO_REPORTING_LEVEL'
AND ((TO_NUMBER(lookup_code) >=
TO_NUMBER(:$PROFILES$.XLA_MO_TOP_REPORTING_LEVEL)
AND NVL(pg.multi_org_flag,'N')='Y')
OR (lookup_code = '1000'
AND NVL(pg.multi_org_flag,'N')='N'))
ORDER BY TO_NUMBER(lookup_code)
Whenever I am trying to find the value of $PROFILES$.XLA_MO_TOP_REPORTING_LEVEL via Help-->EXAMINE
I am getting an error message stating that it is an invalid reference.
0