Advanced Pricing - EBS (MOSC)

MOSC Banner

When QP: Security Control turned on why the policy applied to database with date 04-Aug-2006

Hi,

declare

s varchar2(10000);

begin

    s:= 'e';

    s:=qp_security.qp_vl_sec('APPS','QP_POLICY_LIST_HEADERS_VL');

    dbms_output.put_line('s: ' ||s);

end;

after i turned on the QP: Security Control and then i run the above query, we can see the dbms output as

s: ((list_type_code = 'AGR' ) OR (list_type_code = 'PRL' ) OR (list_type_code in ('SLT','PRO','DLT','DEL','CHARGES')  and nvl(END_DATE_ACTIVE, sysdate)  > '04-Aug-2006'))

why it has condition greater than  '04-Aug-2006'? Is the date hard coded or populated from some where? if populated from some where then where is it coming from?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center