DBA Data[Home] [Help]

APPS.ASL_INV_ITEM_SUMM_PUB dependencies on MTL_ITEM_CATEGORIES

Line 275: MTL_ITEM_CATEGORIES MIC,

271: B.VENDOR_WARRANTY_FLAG,
272: B.PRIMARY_UOM_CODE
273: FROM MTL_SYSTEM_ITEMS_B_KFV B,
274: MTL_SYSTEM_ITEMS_TL ITEM,
275: MTL_ITEM_CATEGORIES MIC,
276: MTL_UNITS_OF_MEASURE_TL UOM
277: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
278: AND MIC.CATEGORY_SET_ID = l_category_set_id
279: AND MIC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID

Line 344: MTL_ITEM_CATEGORIES MIC,

340: B.VENDOR_WARRANTY_FLAG,
341: B.PRIMARY_UOM_CODE
342: FROM MTL_SYSTEM_ITEMS_B_KFV B,
343: MTL_SYSTEM_ITEMS_TL ITEM,
344: MTL_ITEM_CATEGORIES MIC,
345: MTL_UNITS_OF_MEASURE_TL UOM
346: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
347: AND MIC.CATEGORY_SET_ID = l_category_set_id
348: AND MIC.CATEGORY_ID = l_category_id

Line 418: FROM MTL_ITEM_CATEGORIES

414: CURSOR inv_item_id(pl_category_set_id NUMBER,
415: pl_inv_org_id NUMBER,
416: pl_category_id NUMBER) IS
417: SELECT INVENTORY_ITEM_ID
418: FROM MTL_ITEM_CATEGORIES
419: WHERE CATEGORY_SET_ID = pl_category_set_id
420: AND ORGANIZATION_ID = pl_inv_org_id
421: AND CATEGORY_ID = pl_category_id;
422:

Line 481: MTL_ITEM_CATEGORIES MIC,

477: B.SERVICEABLE_PRODUCT_FLAG ,
478: 'Y' -- Active Flag to be 'Y'
479: FROM MTL_SYSTEM_ITEMS_B_KFV B,
480: MTL_SYSTEM_ITEMS_TL ITEM,
481: MTL_ITEM_CATEGORIES MIC,
482: MTL_UNITS_OF_MEASURE_TL UOM
483: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
484: AND MIC.CATEGORY_SET_ID = l_category_set_id
485: AND MIC.CATEGORY_ID = l_category_id

Line 504: MTL_ITEM_CATEGORIES MIC,

500: -- if we do not put this part of code and if select does not get records update will raise ora error
501: AND EXISTS (SELECT 1 FROM
502: MTL_SYSTEM_ITEMS_B_KFV B,
503: MTL_SYSTEM_ITEMS_TL ITEM,
504: MTL_ITEM_CATEGORIES MIC,
505: MTL_UNITS_OF_MEASURE_TL UOM
506: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
507: AND MIC.CATEGORY_SET_ID = l_category_set_id
508: AND MIC.CATEGORY_ID = l_category_id

Line 575: MTL_ITEM_CATEGORIES MIC,

571: B.VENDOR_WARRANTY_FLAG,
572: B.PRIMARY_UOM_CODE
573: FROM MTL_SYSTEM_ITEMS_B_KFV B,
574: MTL_SYSTEM_ITEMS_TL ITEM,
575: MTL_ITEM_CATEGORIES MIC,
576: MTL_UNITS_OF_MEASURE_TL UOM
577: WHERE MIC.ORGANIZATION_ID = l_inv_org_id
578: AND MIC.CATEGORY_SET_ID = l_category_set_id
579: AND MIC.CATEGORY_ID = l_category_id

Line 666: FROM MTL_ITEM_CATEGORIES

662:
663: CURSOR cat_id(pl_category_set_id NUMBER,
664: pl_inv_org_id NUMBER) IS
665: SELECT CATEGORY_ID
666: FROM MTL_ITEM_CATEGORIES
667: WHERE CATEGORY_SET_ID = pl_category_set_id
668: AND ORGANIZATION_ID = pl_inv_org_id;
669:
670: BEGIN