DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_SYSTEM_ITEMS_B

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