1013: /*
1014: || Commented by vkaranam for Bug 5186391
1015: ||
1016: || SELECT count(1)
1017: || FROM cst_item_cost_details
1018: || WHERE inventory_item_id = cp_item_id
1019: || AND organization_id = cp_organization_id
1020: || AND cost_element_id = 2 --Indicates Material OverHead
1021: || AND basis_type = 5 --Total Value Basis
1025: || ); */
1026:
1027: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS
1028: SELECT a.resource_id, a.usage_rate_or_amount, b.absorption_account
1029: FROM cst_item_cost_details a, bom_resources b
1030: WHERE a.resource_id = b.resource_id
1031: AND a.organization_id = cp_organization_id
1032: AND a.inventory_item_id = cp_item_id
1033: AND a.cost_element_id = 2 --Indicates Material OverHead