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