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.QP_CATEGORY_MAPPING_RULE dependencies on QP_PTE_REQUEST_TYPES_B

Line 75: FROM QP_PTE_REQUEST_TYPES_B REQ,

71: AND c.category_set_id = d.category_set_id
72: AND b.structure_id = d.structure_id
73: AND nvl(d.hierarchy_enabled,'N') = 'N'
74: AND c.functional_area_id in (SELECT distinct FNAREA.FUNCTIONAL_AREA_ID
75: FROM QP_PTE_REQUEST_TYPES_B REQ,
76: QP_PTE_SOURCE_SYSTEMS SOU,
77: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
78: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in and REQ.ENABLED_FLAG = 'Y' and
79: REQ.PTE_CODE = SOU.PTE_CODE and SOU.ENABLED_FLAG = 'Y'and

Line 99: FROM QP_PTE_REQUEST_TYPES_B REQ,

95: a.object_id = c.category_set_id and
96: b.category_id = a.child_id and
97: c.functional_area_id in (SELECT /*+ ORDERED USE_NL(REQ SOU FNAREA)*/
98: distinct FNAREA.FUNCTIONAL_AREA_ID
99: FROM QP_PTE_REQUEST_TYPES_B REQ,
100: QP_PTE_SOURCE_SYSTEMS SOU,
101: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
102: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in
103: and REQ.ENABLED_FLAG = 'Y'