[Home] [Help]
4: /* **************************************************************************************************
5: * FUNCTION
6: * cmcommon_get_cost
7: * DESCRIPTION
8: * Retrieves item cost, cost type and fmeff_id from gl_item_cst
9: * and cmptcost_amt from gl_item_dtl get_cost should return the cost of the item
10: * for the cost warehouse if there is a cost warehouse associated with the given
11: * warehouse else it should return the cost of the item for the given warehouse
12: *
309: * This function is an overloaded function of get cost routine. This function
310: * can be used to get costs for non lot cost method or lot cost method.
311: *
312: * For non lot cost method this function retrieves item cost, cost type
313: * and fmeff_id from gl_item_cst and cmptcost_amt from gl_item_dtl
314: * get_cost should return the cost of the item for the cost warehouse
315: * if there is a cost warehouse associated with the given warehouse else
316: * it should return the cost of the item for the given warehouse
317: *
413: * This function is an overloaded function of get cost routine. This function *
414: * can be used to get costs for non lot cost method or lot cost method. *
415: * *
416: * For non lot cost method this function retrieves item cost, cost type *
417: * and fmeff_id from gl_item_cst and cmptcost_amt from gl_item_dtl *
418: * get_cost should return the cost of the item for the cost warehouse *
419: * if there is a cost warehouse associated with the given warehouse else *
420: * it should return the cost of the item for the given warehouse *
421: * *
477:
478: l_api_name CONSTANT VARCHAR2(30) := 'Get_Process_Item_Cost' ;
479: l_api_version CONSTANT NUMBER := 1.0 ;
480:
481: X_itemcost_id gl_item_cst.itemcost_id%TYPE;
482: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;
483: X_no_recs NUMBER(10);
484: i INTEGER;
485: p_cost_type_id cm_mthd_mst.cost_type_id%type;
573: SELECT acctg_cost,
574: cost_type,
575: fmeff_id,
576: itemcost_id
577: FROM gl_item_cst
578: WHERE organization_id = v_organization_id
579: AND inventory_item_id = v_item_id
580: AND cost_type_id = v_cost_type_id
581: AND period_id = v_period_id;
597: SELECT acctg_cost,
598: cost_type,
599: fmeff_id,
600: itemcost_id
601: FROM gl_item_cst
602: WHERE organization_id = v_organization_id
603: AND inventory_item_id = v_item_id
604: AND cost_type_id = v_cost_type_id
605: AND end_date >= v_trans_date
1234: * This function is an overloaded function of get cost routine. This function *
1235: * can be used to get costs for non lot cost method or lot cost method. *
1236: * *
1237: * For non lot cost method this function retrieves item cost, cost type *
1238: * and fmeff_id from gl_item_cst and cmptcost_amt from gl_item_dtl *
1239: * get_cost should return the cost of the item for the cost warehouse *
1240: * if there is a cost warehouse associated with the given warehouse else *
1241: * it should return the cost of the item for the given warehouse *
1242: * *
2446: * FUNCTION
2447: * get_cmpt_cost
2448: * DESCRIPTION
2449: *
2450: * This function gets item unit cost from cm_cmpt_dtl, NOT from gl_item_cst/dtl.
2451: * This is being use in OPM Batch Cost Detail Report.
2452: *
2453: * AUTHOR
2454: * Anand Thiyagarajan 20-Feb-2007 Bug#5436964 Batches Across Periods FP