APPS.QP_CATEGORY_MAPPING_RULE dependencies on QP_SOURCESYSTEM_FNAREA_MAP

Line 84: QP_SOURCESYSTEM_FNAREA_MAP FNAREA

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
88: FNAREA.ENABLED_FLAG = 'Y');*/

Line 107: QP_SOURCESYSTEM_FNAREA_MAP FNAREA

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
111: AND SOU.ENABLED_FLAG = 'Y'

Line 134: QP_SOURCESYSTEM_FNAREA_MAP FNAREA

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
138: and SOU.ENABLED_FLAG = 'Y'

Line 149: QP_SOURCESYSTEM_FNAREA_MAP FNAREA,

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
153: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in AND