DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_CATEGORY_SETS_VL

Line 197: FROM mtl_category_sets_vl

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

Line 672: FROM mtl_category_sets_vl

668: SELECT Category_id
669: INTO l_old_category_id
670: FROM Mtl_Categories_B_Kfv
671: WHERE Structure_Id = ( SELECT Structure_Id
672: FROM mtl_category_sets_vl
673: WHERE category_set_id = l_category_set_id )
674: AND Concatenated_Segments = icoi_rec.old_category_name
675: AND NVL(disable_date,SYSDATE+1) > SYSDATE; -- fix bug 15949266
676: EXCEPTION