[Home] [Help]
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: *
13: * AUTHOR
32: * OUTPUT PARAMETERS
33: * P_acctg_cost = used to receive acctg_cost
34: * P_cost_type = used to receive cost_type
35: * P_fmeff_id = used to receive fmeff_id
36: * P_cmntcost_amt() = used to receive cmptcost_amt from gl_item_dtl
37: * P_cost_cmpntcls_id() = for retrieve mode 4 Component Class Ids
38: * P_cost_analysis_code = for retrieve mode 4 Analysis Codes
39: *
40: * total_cost = This out parameter should be reffered only in the
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: *
339: * OUTPUT PARAMETERS
340: * P_acctg_cost = used to receive acctg_cost
341: * P_cost_type = used to receive cost_type
342: * P_fmeff_id = used to receive fmeff_id
343: * P_cmntcost_amt() = used to receive cmptcost_amt from gl_item_dtl
344: * P_cost_cmpntcls_id() = for retrieve mode 4 Component Class Ids
345: * P_cost_analysis_code = for retrieve mode 4 Analysis Codes
346: *
347: * total_cost = This out parameter should be reffered only in the
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: * *
618: v_analysis_code IN VARCHAR2
619: )
620: IS
621: SELECT cmptcost_amt
622: FROM gl_item_dtl
623: WHERE itemcost_id = v_itemcost_id
624: AND cost_cmpntcls_id = v_cmpntcls_id
625: AND cost_analysis_code = v_analysis_code;
626:
638: IS
639: SELECT cmptcost_amt,
640: i.cost_cmpntcls_id,
641: i.cost_analysis_code
642: FROM gl_item_dtl i,
643: cm_cmpt_mst c
644: WHERE i.itemcost_id = v_itemcost_id
645: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
646: AND c.ppv_ind = 1;
654: v_itemcost_id IN NUMBER
655: )
656: IS
657: SELECT SUM(cmptcost_amt)
658: FROM gl_item_dtl i,
659: cm_cmpt_mst c
660: WHERE i.itemcost_id = v_itemcost_id
661: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
662: AND c.ppv_ind = 1;
1119: p_cost_component_class_id := 0;
1120: END IF;
1121:
1122: /******************************************
1123: * select co cmptcost_amt from gl_item_dtl *
1124: ******************************************/
1125: x_no_recs := 0;
1126: P_no_of_rows := 0;
1127:
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: * *