DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 3088: --FROM mtl_item_categories ic

3084: BEGIN
3085: IF (p_category_id IS NOT NULL AND
3086: l_profile IS NOT NULL ) THEN
3087: SELECT 'x' INTO l_dummy
3088: --FROM mtl_item_categories ic
3089: FROM mtl_category_set_valid_cats ic
3090: WHERE ic.category_id = p_category_id
3091: AND ic.category_set_id = l_profile;
3092: --AND ic.organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id;

Line 3156: FROM mtl_item_categories

3152: AND category_set_id = p_category_set_id;
3153: ELSIF (p_inventory_item_id IS NOT NULL) THEN
3154: l_validation := 'I';
3155: SELECT 'x' INTO l_dummy
3156: FROM mtl_item_categories
3157: WHERE inventory_item_id = p_inventory_item_id
3158: AND category_id = p_category_id
3159: AND category_set_id = p_category_set_id
3160: --AND organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id;

Line 4155: mtl_item_categories ic

4151:
4152: SELECT NVL(revision_qty_control_code,0)
4153: INTO l_control_code
4154: FROM mtl_system_items_vl item,
4155: mtl_item_categories ic
4156: WHERE item.organization_id = p_organization_id
4157: AND item.inventory_item_id = p_platform_id
4158: AND item.organization_id = ic.organization_id
4159: AND item.inventory_item_id = ic.inventory_item_id