[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: * *
473:
474: l_api_name CONSTANT VARCHAR2(30) := 'Get_Process_Item_Cost' ;
475: l_api_version CONSTANT NUMBER := 1.0 ;
476:
477: X_itemcost_id gl_item_cst.itemcost_id%TYPE;
478: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;
479: X_no_recs NUMBER(10);
480: i INTEGER;
481: p_cost_type_id cm_mthd_mst.cost_type_id%type;
569: SELECT acctg_cost,
570: cost_type,
571: fmeff_id,
572: itemcost_id
573: FROM gl_item_cst
574: WHERE organization_id = v_organization_id
575: AND inventory_item_id = v_item_id
576: AND cost_type_id = v_cost_type_id
577: AND period_id = v_period_id;
593: SELECT acctg_cost,
594: cost_type,
595: fmeff_id,
596: itemcost_id
597: FROM gl_item_cst
598: WHERE organization_id = v_organization_id
599: AND inventory_item_id = v_item_id
600: AND cost_type_id = v_cost_type_id
601: AND end_date >= v_trans_date
1062: * This function is an overloaded function of get cost routine. This function *
1063: * can be used to get costs for non lot cost method or lot cost method. *
1064: * *
1065: * For non lot cost method this function retrieves item cost, cost type *
1066: * and fmeff_id from gl_item_cst and cmptcost_amt from gl_item_dtl *
1067: * get_cost should return the cost of the item for the cost warehouse *
1068: * if there is a cost warehouse associated with the given warehouse else *
1069: * it should return the cost of the item for the given warehouse *
1070: * *
2268: * FUNCTION
2269: * get_cmpt_cost
2270: * DESCRIPTION
2271: *
2272: * This function gets item unit cost from cm_cmpt_dtl, NOT from gl_item_cst/dtl.
2273: * This is being use in OPM Batch Cost Detail Report.
2274: *
2275: * AUTHOR
2276: * Anand Thiyagarajan 20-Feb-2007 Bug#5436964 Batches Across Periods FP