APPS.INV_LPN_TRX_PUB dependencies on MTL_SYSTEM_ITEMS

Line 233: FROM mtl_system_items

229: v_mmtt_rec.lot_number :=curlpnrec.lot_number; --bug 8526601
230:
231: SELECT primary_uom_code
232: INTO l_temp_uom_code
233: FROM mtl_system_items
234: WHERE inventory_item_id = v_mmtt_rec.inventory_item_id
235: AND organization_id = v_mmtt_rec.organization_id;
236:
237: SELECT sum(primary_quantity) , sum(quantity)

Line 662: FROM mtl_system_items

658: END IF;
659:
660: SELECT primary_uom_code
661: INTO l_primary_uom
662: FROM mtl_system_items
663: WHERE inventory_item_id = curlpnrec.content_item_id
664: AND organization_id = curlpnrec.organization_id;
665:
666: --bug 8526601 added lot number and org id to make the inv_convert call lot specific

Line 1384: FROM mtl_system_items_b

1380: between the primary UOM and current U0M for the current item.*/
1381: BEGIN
1382: SELECT primary_uom_code
1383: INTO l_primary_uom
1384: FROM mtl_system_items_b
1385: WHERE inventory_item_id = curlpnrec.content_item_id
1386: AND organization_id = curlpnrec.organization_id;
1387: EXCEPTION WHEN OTHERS THEN
1388: NULL;

Line 3301: FROM mtl_system_items_b

3297:
3298: -- 16493898 start
3299: SELECT tracking_quantity_ind
3300: INTO l_tracking_quantity_ind
3301: FROM mtl_system_items_b
3302: WHERE organization_id = p_org_id
3303: AND inventory_item_id = p_item_rec.inventory_item_id;
3304: -- 16493898 end
3305:

Line 3630: from mtl_system_items_b msib

3626: from mtl_parameters mp
3627: where mp.organization_id = mmt.organization_id
3628: and process_enabled_flag = 'Y')
3629: AND exists (select 1
3630: from mtl_system_items_b msib
3631: where msib.inventory_item_id = mmt.inventory_item_id
3632: and msib.organization_id = mmt.organization_id
3633: and msib.process_quality_enabled_flag = 'Y')
3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue