DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on MTL_PARAMETERS

Line 777: FROM MTL_PARAMETERS MP

773: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
774: MP.PRIMARY_COST_METHOD
775: INTO l_cost_group_id, l_cost_type_id,
776: l_primary_cost_method
777: FROM MTL_PARAMETERS MP
778: WHERE ORGANIZATION_ID = p_org_id;
779:
780: SELECT EXTENDED_PRECISION
781: INTO l_ext_precision

Line 967: FROM MTL_PARAMETERS MP

963: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
964: MP.PRIMARY_COST_METHOD
965: INTO l_cost_group_id, l_cost_type_id,
966: l_primary_cost_method
967: FROM MTL_PARAMETERS MP
968: WHERE ORGANIZATION_ID = l_org_id;
969:
970: SELECT EXTENDED_PRECISION
971: INTO l_ext_precision

Line 1500: FROM MTL_PARAMETERS MP

1496: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
1497: MP.PRIMARY_COST_METHOD
1498: INTO l_cost_group_id, l_cost_type_id,
1499: l_primary_cost_method
1500: FROM MTL_PARAMETERS MP
1501: WHERE ORGANIZATION_ID = p_ce_associatin_rec.ORGANIZATION_ID;
1502:
1503: SELECT EXTENDED_PRECISION
1504: INTO l_ext_precision