eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPLENG dependencies on CST_ITEM_COST_DETAILS

Line 3745: from cst_item_cost_details cicd

3741: -- Ensure that resource_id is NOT NULL in CICD
3742: l_stmt_num := 32;
3743: select count(*)
3744: into l_res_id
3745: from cst_item_cost_details cicd
3746: where inventory_item_id = i_item_id
3747: and organization_id = i_org_id
3748: and cost_type_id = i_mat_ct_Id
3749: and basis_type in (1,2,5,6)

Line 3758: update CST_ITEM_COST_DETAILS

3754: if (l_res_id > 0) then /*Changed this if block and inserted the update statement
3755: instead of raising the exception due to bugg 3959770*/
3756:
3757: if (l_default_MOH_subelement is NOT NULL) then
3758: update CST_ITEM_COST_DETAILS
3759: set resource_id = l_default_MOH_subelement
3760: where inventory_item_id = i_item_id
3761: and organization_id = i_org_id
3762: and cost_type_id = i_mat_ct_Id

Line 3818: from cst_item_cost_details cicd

3814: 2, cicd.usage_rate_or_amount/abs(i_txn_qty),
3815: 5, cicd.usage_rate_or_amount * l_item_cost,
3816: 6, cicd.usage_rate_or_amount * cicd.basis_factor,0),
3817: 'N'
3818: from cst_item_cost_details cicd
3819: where inventory_item_id = i_item_id
3820: and organization_id = i_org_id
3821: and cost_type_id = i_mat_ct_Id
3822: and basis_type in (1,2,5,6)

Line 3847: from cst_item_cost_details

3843: cost type */
3844: l_stmt_num := 45;
3845: select count(*)
3846: into l_res_id
3847: from cst_item_cost_details
3848: where cost_type_id = i_avg_rates_id
3849: and inventory_item_id = i_item_id
3850: and organization_id = i_org_id;
3851:

Line 3856: from cst_item_cost_details

3852: if (l_res_id > 0) then
3853: l_stmt_num := 50;
3854: select resource_id
3855: into l_res_id
3856: from cst_item_cost_details
3857: where cost_type_id = i_avg_rates_id
3858: and inventory_item_id = i_item_id
3859: and organization_id = i_org_id
3860: and cost_element_id = 2

Line 3873: update cst_item_cost_details

3869: elsif (l_res_id is NULL) then
3870: if (l_default_MOH_subelement IS NOT NULL) then
3871: l_res_id := l_default_MOH_subelement;
3872:
3873: update cst_item_cost_details
3874: set resource_id = l_default_MOH_subelement
3875: where cost_type_id = i_avg_rates_id
3876: and inventory_item_id = i_item_id
3877: and organization_id = i_org_id