APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_PTE_SOURCE_SYSTEMS

Line 83: QP_PTE_SOURCE_SYSTEMS SOU,

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

Line 106: QP_PTE_SOURCE_SYSTEMS SOU,

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'
110: AND REQ.PTE_CODE = SOU.PTE_CODE

Line 133: QP_PTE_SOURCE_SYSTEMS SOU,

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

Line 148: QP_PTE_SOURCE_SYSTEMS SOU,

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,
152: mtl_item_categories b