DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_PARAMETERS

Line 144: from mtl_parameters

140: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
141: BEGIN
142: select primary_cost_method
143: into l_primary_cost_method
144: from mtl_parameters
145: where organization_id = p_org_id;
146:
147: IF (l_debug = 1) THEN
148: inv_log_util.TRACE('INVTRXWB: cost method of org'||p_org_id||' is '||l_primary_cost_method,'INVTRXWB',1);

Line 3350: from mtl_parameters mp

3346: FROM mtl_material_transactions mmt
3347: WHERE mmt.transaction_set_id = p_trx_hdr_id
3348: AND mmt.transaction_quantity > 0
3349: AND exists (select 1
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