DBA Data[Home] [Help]

APPS.AR_RAAPI_UTIL dependencies on MTL_CATEGORIES_VL

Line 852: FROM mtl_categories_vl

848:
849: /* Bug 2157246 - replaced CHR(0) with FND_API.G_MISS_CHAR */
850: CURSOR c_category_segs (p_segment_rec Segment_Rec_Type) IS
851: SELECT category_id
852: FROM mtl_categories_vl
853: WHERE NVL(segment1,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment1,FND_API.G_MISS_CHAR)
854: AND NVL(segment2,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment2,FND_API.G_MISS_CHAR)
855: AND NVL(segment3,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment3,FND_API.G_MISS_CHAR)
856: AND NVL(segment4,FND_API.G_MISS_CHAR) = NVL(p_segment_rec.segment4,FND_API.G_MISS_CHAR)

Line 877: FROM mtl_categories_vl

873: AND structure_id = g_category_structure_id;
874:
875: CURSOR c_category_id(p_category_id NUMBER) IS
876: SELECT category_id
877: FROM mtl_categories_vl
878: WHERE category_id = p_category_id
879: AND structure_id = g_category_structure_id;
880:
881: CURSOR c_cat_exists_on_trx(p_category_id NUMBER) IS