DBA Data[Home] [Help]

APPS.OKL_SYP_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1371: FROM MTL_ITEM_CATEGORIES MTLITMCATS,

1367: p_category_Set_id IN NUMBER) IS
1368:
1369: CURSOR l_cat_set_csr(cp_cat_set_id IN NUMBER) IS
1370: SELECT 'X'
1371: FROM MTL_ITEM_CATEGORIES MTLITMCATS,
1372: MTL_CATEGORY_SETS MTLCATSETS
1373: WHERE MTLITMCATS.CATEGORY_SET_ID = MTLCATSETS.CATEGORY_SET_ID
1374: AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
1375: AND MTLCATSETS.MULT_ITEM_CAT_ASSIGN_FLAG = 'N'