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 3728: from cst_item_cost_details cicd

3724: -- Ensure that resource_id is NOT NULL in CICD
3725: l_stmt_num := 32;
3726: select count(*)
3727: into l_res_id
3728: from cst_item_cost_details cicd
3729: where inventory_item_id = i_item_id
3730: and organization_id = i_org_id
3731: and cost_type_id = i_mat_ct_Id
3732: and basis_type in (1,2,5,6)

Line 3740: update CST_ITEM_COST_DETAILS

3736: if (l_res_id > 0) then /*Changed this if block and inserted the update statement
3737: instead of raising the exception due to bugg 3959770*/
3738:
3739: if (l_default_MOH_subelement is NOT NULL) then
3740: update CST_ITEM_COST_DETAILS
3741: set resource_id = l_default_MOH_subelement
3742: where inventory_item_id = i_item_id
3743: and organization_id = i_org_id
3744: and cost_type_id = i_mat_ct_Id

Line 3799: from cst_item_cost_details cicd

3795: 2, cicd.usage_rate_or_amount/abs(i_txn_qty),
3796: 5, cicd.usage_rate_or_amount * l_item_cost,
3797: 6, cicd.usage_rate_or_amount * cicd.basis_factor,0),
3798: 'N'
3799: from cst_item_cost_details cicd
3800: where inventory_item_id = i_item_id
3801: and organization_id = i_org_id
3802: and cost_type_id = i_mat_ct_Id
3803: and basis_type in (1,2,5,6)

Line 3828: from cst_item_cost_details

3824: cost type */
3825: l_stmt_num := 45;
3826: select count(*)
3827: into l_res_id
3828: from cst_item_cost_details
3829: where cost_type_id = i_avg_rates_id
3830: and inventory_item_id = i_item_id
3831: and organization_id = i_org_id;
3832:

Line 3837: from cst_item_cost_details

3833: if (l_res_id > 0) then
3834: l_stmt_num := 50;
3835: select resource_id
3836: into l_res_id
3837: from cst_item_cost_details
3838: where cost_type_id = i_avg_rates_id
3839: and inventory_item_id = i_item_id
3840: and organization_id = i_org_id
3841: and cost_element_id = 2

Line 3853: update cst_item_cost_details

3849: elsif (l_res_id is NULL) then
3850: if (l_default_MOH_subelement IS NOT NULL) then
3851: l_res_id := l_default_MOH_subelement;
3852:
3853: update cst_item_cost_details
3854: set resource_id = l_default_MOH_subelement
3855: where cost_type_id = i_avg_rates_id
3856: and inventory_item_id = i_item_id
3857: and organization_id = i_org_id