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_PVT dependencies on OE_PC_ASSIGNMENTS

Line 1530: FROM OE_PC_ASSIGNMENTS A

1526: AND c.check_on_insert_flag = 'Y'
1527: AND nvl(c.enabled_flag, 'Y') = 'Y'
1528: AND EXISTS (
1529: SELECT 'EXISTS'
1530: FROM OE_PC_ASSIGNMENTS A
1531: WHERE a.constraint_id = c.constraint_id
1532: AND ( a.responsibility_id = p_responsibility_id
1533: OR a.responsibility_id IS NULL)
1534: AND ( a.application_id = p_application_id

Line 2069: FROM OE_PC_ASSIGNMENTS A

2065: WHERE c.entity_id = P_ENTITY_ID
2066: AND c.constrained_operation = OE_PC_GLOBALS.CREATE_OP
2067: AND EXISTS (
2068: SELECT 'EXISTS'
2069: FROM OE_PC_ASSIGNMENTS A
2070: WHERE a.constraint_id = c.constraint_id
2071: AND ( a.responsibility_id = p_responsibility_id
2072: OR a.responsibility_id IS NULL)
2073: AND ( a.application_id = p_application_id

Line 2117: FROM OE_PC_ASSIGNMENTS A

2113: AND decode(honored_by_def_flag,'N',decode(p_is_caller_defaulting,'Y','N','Y'),
2114: nvl(honored_by_def_flag,'Y')) = 'Y'
2115: AND EXISTS (
2116: SELECT 'EXISTS'
2117: FROM OE_PC_ASSIGNMENTS A
2118: WHERE a.constraint_id = c.constraint_id
2119: AND ( a.responsibility_id = p_responsibility_id
2120: OR a.responsibility_id IS NULL)
2121: AND ( a.application_id =p_application_id --added for bug3631547

Line 2143: oe_pc_assignments a

2139: SELECT DISTINCT
2140: c.constraint_id, c.entity_id
2141: ,c.on_operation_action, c.column_name
2142: FROM oe_pc_constraints c,
2143: oe_pc_assignments a
2144: WHERE (a.responsibility_id = p_responsibility_id OR a.responsibility_id IS NULL)
2145: AND a.constraint_id = c.constraint_id
2146: AND c.entity_id = P_ENTITY_ID
2147: AND c.constrained_operation = p_operation