APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_PTE_REQUEST_TYPES_B

Line 82: FROM QP_PTE_REQUEST_TYPES_B REQ,

78: AND c.category_set_id = d.category_set_id
79: AND b.structure_id = d.structure_id
80: AND nvl(d.hierarchy_enabled,'N') = 'N'
81: AND c.functional_area_id in (SELECT distinct FNAREA.FUNCTIONAL_AREA_ID
82: FROM QP_PTE_REQUEST_TYPES_B REQ,
83: QP_PTE_SOURCE_SYSTEMS SOU,
84: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
85: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in and REQ.ENABLED_FLAG = 'Y' and
86: REQ.PTE_CODE = SOU.PTE_CODE and SOU.ENABLED_FLAG = 'Y'and

Line 105: FROM QP_PTE_REQUEST_TYPES_B REQ,

101: AND C.CATEGORY_SET_ID = D.CATEGORY_SET_ID
102: AND B.STRUCTURE_ID = D.STRUCTURE_ID
103: AND NVL(D.HIERARCHY_ENABLED,'N') = 'N'
104: AND C.FUNCTIONAL_AREA_ID IN (SELECT /*+ no_unnest */ DISTINCT FNAREA.FUNCTIONAL_AREA_ID
105: FROM QP_PTE_REQUEST_TYPES_B REQ,
106: QP_PTE_SOURCE_SYSTEMS SOU,
107: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
108: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in
109: AND REQ.ENABLED_FLAG = 'Y'

Line 132: FROM QP_PTE_REQUEST_TYPES_B REQ,

128: a.object_id = c.category_set_id and
129: b.category_id = a.child_id and
130: c.functional_area_id in (SELECT /*+ ORDERED USE_NL(REQ SOU FNAREA)*//*
131: distinct FNAREA.FUNCTIONAL_AREA_ID
132: FROM QP_PTE_REQUEST_TYPES_B REQ,
133: QP_PTE_SOURCE_SYSTEMS SOU,
134: QP_SOURCESYSTEM_FNAREA_MAP FNAREA
135: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in
136: and REQ.ENABLED_FLAG = 'Y'

Line 147: from QP_PTE_REQUEST_TYPES_B REQ,

143: CURSOR l_exploded_category_cursor (org_id_in number, req_type_code_in VARCHAR2) is
144: select /*+ leading(x,A) no_merge(x) use_nl_with_index(a ENI_DENORM_HIERARCHIES_N2) */ A.PARENT_ID --bug 8924817
145: from (select /*+ ordered use_nl(req sou fnarea c d b) */ distinct b.category_id,
146: b.category_set_id
147: from QP_PTE_REQUEST_TYPES_B REQ,
148: QP_PTE_SOURCE_SYSTEMS SOU,
149: QP_SOURCESYSTEM_FNAREA_MAP FNAREA,
150: MTL_DEFAULT_CATEGORY_SETS C,
151: mtl_category_sets_b d,