APPS.ASL_INV_ITEM_SUMM_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 276: MTL_UNITS_OF_MEASURE_TL UOM

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
280: AND MIC.ORGANIZATION_ID = B.ORGANIZATION_ID

Line 345: MTL_UNITS_OF_MEASURE_TL UOM

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
349: AND MIC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID

Line 482: MTL_UNITS_OF_MEASURE_TL UOM

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
486: AND B.INVENTORY_ITEM_ID = l_inv_item_id

Line 505: MTL_UNITS_OF_MEASURE_TL UOM

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
509: AND B.INVENTORY_ITEM_ID = l_inv_item_id

Line 576: MTL_UNITS_OF_MEASURE_TL UOM

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
580: AND ITEM.INVENTORY_ITEM_ID = l_inv_item_id