DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_SYSTEM_ITEMS_B

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