DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_CATEGORY_SETS_VL

Line 194: FROM mtl_category_sets_vl

190: ( p_category_set_name IN VARCHAR2
191: )
192: IS
193: SELECT category_set_id, structure_id
194: FROM mtl_category_sets_vl
195: WHERE category_set_name = p_category_set_name;
196:
197: CURSOR msi_item_number_csr (cp_item_number IN VARCHAR2,
198: cp_organization_id IN NUMBER)

Line 665: FROM mtl_category_sets_vl

661: SELECT Category_id
662: INTO l_old_category_id
663: FROM Mtl_Categories_B_Kfv
664: WHERE Structure_Id = ( SELECT Structure_Id
665: FROM mtl_category_sets_vl
666: WHERE category_set_id = l_category_set_id )
667: AND Concatenated_Segments = icoi_rec.old_category_name;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN