DBA Data[Home] [Help]

APPS.JTF_DSPMGRVALIDATION_GRP dependencies on MTL_ITEM_CATEGORIES

Line 1319: (SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where

1315:
1316: CURSOR item_dlv_cur(p_item_id in NUMBER,
1317: p_deliverable_id IN NUMBER ) IS
1318: SELECT 1 from dual where exists
1319: (SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
1320: B.INVENTORY_ITEM_ID = p_item_id and
1321: B.CATEGORY_ID = A.CATEGORY_ID AND
1322: A.ITEM_ID= p_deliverable_id );
1323: