DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on MTL_PARAMETERS

Line 3614: from mtl_parameters

3610: /* Get the Default MOH sub element of the organization*/
3611:
3612: select DEFAULT_MATL_OVHD_COST_ID
3613: into l_default_MOH_subelement
3614: from mtl_parameters
3615: where organization_id= I_ORG_ID;
3616:
3617:
3618: -- Find out if there are any material overhead rows for the layer

Line 4735: from mtl_parameters

4731: -- references enabled. The cost will be updated in CLCD, but not in CICD.
4732:
4733: /* select nvl(project_reference_enabled,0)
4734: into l_proj_enabled
4735: from mtl_parameters
4736: where organization_id = i_org_id;
4737:
4738: if (l_proj_enabled = 2) then
4739: l_mandatory_update := 1;

Line 5207: from mtl_parameters

5203:
5204: /* Get the cost method for the org */
5205: select primary_cost_method
5206: into l_cost_method
5207: from mtl_parameters
5208: where organization_id = I_ORG_ID;
5209:
5210: if (l_cost_method = 5) then
5211: /* Try to return the first positive layer */

Line 5935: from mtl_parameters

5931:
5932: l_stmt_num := 3;
5933: select decode(encumbrance_reversal_flag,1,1,2,0,0)
5934: into l_enc_rev
5935: from mtl_parameters
5936: where organization_id = i_org_id;
5937:
5938: l_stmt_num := 4;
5939:

Line 6006: MTL_PARAMETERS

6002: l_inv_ovhd_acct,
6003: l_inv_osp_acct,
6004: l_avg_cost_var_acct
6005: FROM
6006: MTL_PARAMETERS
6007: WHERE
6008: ORGANIZATION_ID = i_org_id;
6009: END IF;
6010: EXCEPTION