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 3626: from mtl_parameters mp

3622: FROM mtl_material_transactions mmt
3623: WHERE mmt.transaction_set_id = p_trx_hdr_id
3624: AND mmt.transaction_quantity > 0
3625: AND exists (select 1
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

Line 4747: FROM MTL_PARAMETERS

4743: /*Bug14298387,added the validation on logic locator to call pjm api GET_PHYSICAL_LOCATION*/
4744: BEGIN
4745: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
4746: INTO l_project_ref_enabled
4747: FROM MTL_PARAMETERS
4748: WHERE ORGANIZATION_ID = v_mmtt.organization_id ;
4749: EXCEPTION
4750: WHEN NO_DATA_FOUND THEN
4751: l_project_ref_enabled := 0;

Line 4802: FROM MTL_PARAMETERS

4798: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=3)THEN --org direct xfer
4799: BEGIN
4800: SELECT DECODE(NVL(PROJECT_REFERENCE_ENABLED, 2),1,1,0)
4801: INTO l_project_ref_enabled
4802: FROM MTL_PARAMETERS
4803: WHERE ORGANIZATION_ID = v_mmtt.transfer_organization ;
4804: EXCEPTION
4805: WHEN NO_DATA_FOUND THEN
4806: l_project_ref_enabled := 0;