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.

APPS.OE_PC_CONSTRAINTS_ADMIN_PUB dependencies on OE_PC_ASSIGNMENTS

Line 470: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');

466: utl_file.put_line(l_bodyFileHandle , ' c.constraint_id, c.entity_id');
467: utl_file.put_line(l_bodyFileHandle , ' ,c.on_operation_action');
468: --utl_file.put_line(l_bodyFileHandle , ' ,c.message_name');
469: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');
470: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');
471: utl_file.put_line(l_bodyFileHandle , ' WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)');
472: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(a.start_date_active, sysdate) AND nvl(a.end_date_active, sysdate)');
473: utl_file.put_line(l_bodyFileHandle , ' AND a.constraint_id = c.constraint_id');
474: utl_file.put_line(l_bodyFileHandle , ' AND c.entity_id = G_ENTITY_ID');

Line 502: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');

498: utl_file.put_line(l_bodyFileHandle , ' c.constraint_id, c.entity_id');
499: utl_file.put_line(l_bodyFileHandle , ' ,c.on_operation_action');
500: --utl_file.put_line(l_bodyFileHandle , ' ,c.message_name');
501: utl_file.put_line(l_bodyFileHandle , ' FROM oe_pc_constraints c,');
502: utl_file.put_line(l_bodyFileHandle , ' oe_pc_assignments a');
503: utl_file.put_line(l_bodyFileHandle , ' WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)');
504: utl_file.put_line(l_bodyFileHandle , ' AND a.application_id = p_application_id OR a.application_id IS NULL'); --bug3631547
505: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(a.start_date_active, sysdate) AND nvl(a.end_date_active, sysdate)');
506: utl_file.put_line(l_bodyFileHandle , ' AND a.constraint_id = c.constraint_id');

Line 624: FROM OE_PC_ASSIGNMENTS

620: SELECT 'FND_RESP'||R.application_id||':'||R.responsibility_id role_name
621: , R.responsibility_name role_display_name
622: FROM FND_RESPONSIBILITY_VL R
623: WHERE R.responsibility_id NOT IN (SELECT NVL(responsibility_id,R.responsibility_id)
624: FROM OE_PC_ASSIGNMENTS
625: WHERE CONSTRAINT_ID = p_constraint_id
626: )
627: ORDER BY role_display_name;
628:

Line 635: FROM oe_pc_assignments

631: , R.responsibility_name role_display_name
632: FROM FND_RESPONSIBILITY_VL R
633: , OE_PC_EXCLUSIONS E
634: WHERE E.assignment_id = (SELECT assignment_id
635: FROM oe_pc_assignments
636: WHERE constraint_id = p_constraint_id
637: AND responsibility_id IS NULL)
638: AND E.responsibility_id = R.responsibility_id
639: AND E.application_id = R.application_id --added for bug3631547