[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: * *
614: v_analysis_code IN VARCHAR2
615: )
616: IS
617: SELECT cmptcost_amt
618: FROM gl_item_dtl
619: WHERE itemcost_id = v_itemcost_id
620: AND cost_cmpntcls_id = v_cmpntcls_id
621: AND cost_analysis_code = v_analysis_code;
622:
634: IS
635: SELECT cmptcost_amt,
636: i.cost_cmpntcls_id,
637: i.cost_analysis_code
638: FROM gl_item_dtl i,
639: cm_cmpt_mst c
640: WHERE i.itemcost_id = v_itemcost_id
641: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
642: AND c.ppv_ind = 1;
650: v_itemcost_id IN NUMBER
651: )
652: IS
653: SELECT SUM(cmptcost_amt)
654: FROM gl_item_dtl i,
655: cm_cmpt_mst c
656: WHERE i.itemcost_id = v_itemcost_id
657: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
658: AND c.ppv_ind = 1;
947: p_cost_component_class_id := 0;
948: END IF;
949:
950: /******************************************
951: * select co cmptcost_amt from gl_item_dtl *
952: ******************************************/
953: x_no_recs := 0;
954: P_no_of_rows := 0;
955:
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: * *