DBA Data[Home] [Help]

APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_PTE_SOURCE_SYSTEMS

Line 76: QP_PTE_SOURCE_SYSTEMS SOU,

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
80: SOU.PTE_SOURCE_SYSTEM_ID = FNAREA.PTE_SOURCE_SYSTEM_ID and

Line 100: QP_PTE_SOURCE_SYSTEMS SOU,

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'
104: and REQ.PTE_CODE = SOU.PTE_CODE