DBA Data[Home] [Help]

APPS.CST_SUBELEMENTS_PVT dependencies on MTL_PARAMETERS

Line 803: FROM mtl_parameters mp, wsm_parameters wsm

799: -- set to wsm org flag
800:
801: SELECT COUNT(*)
802: INTO l_to_wsm_flag
803: FROM mtl_parameters mp, wsm_parameters wsm
804: WHERE wsm.organization_id = p_to_organization_id
805: AND mp.organization_id = wsm.organization_id
806: AND UPPER(mp.wsm_enabled_flag)='Y';
807:

Line 1113: FROM mtl_parameters

1109:
1110: SELECT decode(project_reference_enabled,1,
1111: decode(pm_cost_collection_enabled,1,1,0),0)
1112: INTO l_exp_type_required
1113: FROM mtl_parameters
1114: WHERE organization_id = p_to_organization_id;
1115:
1116: l_statement := 170;
1117:

Line 1645: FROM mtl_parameters mp

1641: SELECT mp.expense_account,
1642: mp.expense_account
1643: INTO x_scrap_account,
1644: x_est_absorption_account
1645: FROM mtl_parameters mp
1646: WHERE mp.organization_id = p_to_organization_id;
1647:
1648:
1649: ---------------------------------------------------------------------------

Line 2183: FROM mtl_parameters mp,

2179: mp.expense_account),
2180: mp.expense_account
2181: INTO x_absorption_account,
2182: x_rate_variance_account
2183: FROM mtl_parameters mp,
2184: bom_resources br
2185: WHERE mp.organization_id = p_to_organization_id
2186: AND br.resource_id = p_resource_id;
2187:

Line 2555: FROM MTL_PARAMETERS MP

2551: /* ********** Added for to_org is a Std Cost Org, have to handle NULL subelements ***** */
2552:
2553: SELECT primary_cost_method
2554: INTO l_primary_cost_method
2555: FROM MTL_PARAMETERS MP
2556: WHERE MP.organization_id = p_to_organization_id;
2557:
2558: IF (l_primary_cost_method = 1) THEN
2559: