DBA Data[Home] [Help]

APPS.CS_SR_RES_CODE_MAPPING_PKG dependencies on MTL_ITEM_CATEGORIES

Line 111: exists (select category_id from mtl_item_categories cmtlc

107: cstl.problem_code is null)
108: or
109: ( cstl.incident_type_id = l_incident_type_id and
110: cstl.inventory_item_id is null and
111: exists (select category_id from mtl_item_categories cmtlc
112: where
113: cmtlc.category_id = cstl.category_id and
114: category_set_id = l_category_set_id and /* value from profile CS_SR_DEFAULT_CATEGORY_SET */
115: cmtlc.inventory_item_id = l_inventory_item_id and

Line 132: exists (select category_id from mtl_item_categories cmtlc

128: cstl.category_id is null)
129: or
130: ( cstl.incident_type_id = l_incident_type_id and
131: cstl.problem_code = l_problem_code and
132: exists (select category_id from mtl_item_categories cmtlc
133: where
134: cmtlc.category_id = cstl.category_id and
135: cmtlc.category_set_id = l_category_set_id and /* value from profile CS_SR_DEFAULT_CATEGORY_SET */
136: cmtlc.inventory_item_id = l_inventory_item_id and

Line 198: exists (select category_id from mtl_item_categories cmtlc

194: and
195: (
196: ( cstl.incident_type_id is null and
197: cstl.inventory_item_id is null and
198: exists (select category_id from mtl_item_categories cmtlc
199: where
200: cmtlc.category_id = cstl.category_id and
201: cmtlc.category_set_id = l_category_set_id and /* value from profile CS_SR_DEFAULT_CATEGORY_SET */
202: cmtlc.inventory_item_id = l_inventory_item_id and

Line 208: exists (select category_id from mtl_item_categories cmtlc

204: cstl.problem_code is null)
205: or
206: ( cstl.incident_type_id is null and
207: cstl.inventory_item_id is null and
208: exists (select category_id from mtl_item_categories cmtlc
209: where
210: cmtlc.category_id = cstl.category_id and
211: category_set_id = l_category_set_id and /* value from profile CS_SR_DEFAULT_CATEGORY_SET */
212: cmtlc.inventory_item_id = l_inventory_item_id) and