APPS.INV_LPN_TRX_PUB dependencies on MTL_SYSTEM_ITEMS

Line 215: FROM mtl_system_items

211: v_mmtt_rec.secondary_uom_code := curlpnrec.sec_uom;--INVCONV kkillams
212:
213: SELECT primary_uom_code
214: INTO l_temp_uom_code
215: FROM mtl_system_items
216: WHERE inventory_item_id = v_mmtt_rec.inventory_item_id
217: AND organization_id = v_mmtt_rec.organization_id;
218:
219: IF v_mmtt_rec.transaction_uom <> l_temp_uom_code THEN --Added bug 3984746

Line 483: FROM mtl_system_items

479: END;
480:
481: SELECT primary_uom_code
482: INTO l_primary_uom
483: FROM mtl_system_items
484: WHERE inventory_item_id = curlpnrec.content_item_id
485: AND organization_id = curlpnrec.organization_id;
486:
487: l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id, 6, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);

Line 1174: FROM mtl_system_items_b

1170: between the primary UOM and current U0M for the current item.*/
1171: BEGIN
1172: SELECT primary_uom_code
1173: INTO l_primary_uom
1174: FROM mtl_system_items_b
1175: WHERE inventory_item_id = curlpnrec.content_item_id
1176: AND organization_id = curlpnrec.organization_id;
1177: EXCEPTION WHEN OTHERS THEN
1178: NULL;

Line 3354: from mtl_system_items_b msib

3350: from mtl_parameters mp
3351: where mp.organization_id = mmt.organization_id
3352: and process_enabled_flag = 'Y')
3353: AND exists (select 1
3354: from mtl_system_items_b msib
3355: where msib.inventory_item_id = mmt.inventory_item_id
3356: and msib.organization_id = mmt.organization_id
3357: and msib.process_quality_enabled_flag = 'Y')
3358: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue