DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_CATEGORIES_KFV

Line 2337: , MTL_CATEGORIES_KFV kfv

2333: )
2334: IS
2335: SELECT distinct kfv.CONCATENATED_SEGMENTS
2336: FROM MTL_ITEM_CATEGORIES mic1
2337: , MTL_CATEGORIES_KFV kfv
2338: WHERE kfv.CATEGORY_ID = mic1.CATEGORY_ID
2339: AND mic1.ORGANIZATION_ID = p_model_org_id
2340: AND NOT EXISTS
2341: ( SELECT 'x'

Line 2351: , MTL_CATEGORIES_KFV kfv

2347: CURSOR l_cnt_csr ( p_org_id NUMBER )
2348: IS
2349: SELECT COUNT(DISTINCT kfv.CONCATENATED_SEGMENTS)
2350: FROM MTL_ITEM_CATEGORIES mic1
2351: , MTL_CATEGORIES_KFV kfv
2352: WHERE kfv.CATEGORY_ID = mic1.CATEGORY_ID
2353: AND mic1.ORGANIZATION_ID = p_org_id;
2354:
2355: BEGIN