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.AHL_PP_MATERIALS_PVT dependencies on AHL_APPROVERS

Line 6096: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B

6092: A.APPROVAL_OBJECT_CODE,
6093: A.STATUS_CODE,
6094: B.APPROVER_NAME,
6095: B.APPROVER_SEQUENCE
6096: FROM AHL_APPROVAL_RULES_B A,AHL_APPROVERS_V B
6097: WHERE A.APPROVAL_RULE_ID=B.APPROVAL_RULE_ID
6098: AND A.STATUS_CODE='ACTIVE'
6099: AND A.APPROVAL_OBJECT_CODE=c_object_type
6100: ORDER BY B.APPROVER_SEQUENCE;

Line 6104: * Balaji blown open AHL_APPROVERS_V since it introduces NMV

6100: ORDER BY B.APPROVER_SEQUENCE;
6101: */
6102: /*
6103: * R12 Perf Tuning
6104: * Balaji blown open AHL_APPROVERS_V since it introduces NMV
6105: * due to Unions in the query. Reference bug # 4919273 and 4919045
6106: */
6107: SELECT DISTINCT
6108: JRREV.USER_NAME APPROVER_NAME

Line 6110: AHL_APPROVERS AA,

6106: */
6107: SELECT DISTINCT
6108: JRREV.USER_NAME APPROVER_NAME
6109: FROM
6110: AHL_APPROVERS AA,
6111: FND_LOOKUP_VALUES_VL FNDA,
6112: AHL_JTF_RS_EMP_V JRREV,
6113: AHL_APPROVAL_RULES_B APR
6114: WHERE

Line 6125: AHL_APPROVERS AA,

6121: UNION
6122: SELECT DISTINCT
6123: JRRV.ROLE_NAME APPROVER_NAME
6124: FROM
6125: AHL_APPROVERS AA,
6126: FND_LOOKUP_VALUES_VL FNDA,
6127: JTF_RS_ROLE_RELATIONS_VL JRRV,
6128: AHL_APPROVAL_RULES_B APR
6129: WHERE

Line 6140: AHL_APPROVERS AA,

6136: UNION
6137: SELECT DISTINCT
6138: '' APPROVER_NAME
6139: FROM
6140: AHL_APPROVERS AA,
6141: FND_LOOKUP_VALUES_VL FNDA,
6142: AHL_APPROVAL_RULES_B APR
6143: WHERE
6144: FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'