DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on MTL_PARAMETERS

Line 3597: from mtl_parameters

3593: /* Get the Default MOH sub element of the organization*/
3594:
3595: select DEFAULT_MATL_OVHD_COST_ID
3596: into l_default_MOH_subelement
3597: from mtl_parameters
3598: where organization_id= I_ORG_ID;
3599:
3600:
3601: -- Find out if there are any material overhead rows for the layer

Line 4631: from mtl_parameters

4627: -- references enabled. The cost will be updated in CLCD, but not in CICD.
4628:
4629: /* select nvl(project_reference_enabled,0)
4630: into l_proj_enabled
4631: from mtl_parameters
4632: where organization_id = i_org_id;
4633:
4634: if (l_proj_enabled = 2) then
4635: l_mandatory_update := 1;

Line 5103: from mtl_parameters

5099:
5100: /* Get the cost method for the org */
5101: select primary_cost_method
5102: into l_cost_method
5103: from mtl_parameters
5104: where organization_id = I_ORG_ID;
5105:
5106: if (l_cost_method = 5) then
5107: /* Try to return the first positive layer */

Line 5831: from mtl_parameters

5827:
5828: l_stmt_num := 3;
5829: select decode(encumbrance_reversal_flag,1,1,2,0,0)
5830: into l_enc_rev
5831: from mtl_parameters
5832: where organization_id = i_org_id;
5833:
5834: l_stmt_num := 4;
5835:

Line 5902: MTL_PARAMETERS

5898: l_inv_ovhd_acct,
5899: l_inv_osp_acct,
5900: l_avg_cost_var_acct
5901: FROM
5902: MTL_PARAMETERS
5903: WHERE
5904: ORGANIZATION_ID = i_org_id;
5905: END IF;
5906: EXCEPTION