[Home] [Help]
74: --| order by trunc(transaction_date), |
75: --| transaction_id bug#3002073 fix |
76: --| 06/22/2003 vjavli Bug#3013597 fix: cost type of the |
77: --| organization is to be verified. If cost|
78: --| type is Standard then Begin Unit Cost |
79: --| will be actual cost of very first txn |
80: --| and End Unit Cost will be actual cost |
81: --| of last txn. If Cost Type is Average, |
82: --| LIFO, FIFO then Begin Unit Cost will be|
105: --| CST_MGD_MSTR_BOOK_TEMP |
106: --| 02/24/2006 vmutyala Bug # 4912772 Performance issue in the |
107: --| dynamic query in Create_Inv_Msbk_Rpt is|
108: --| resolved by restructuring the query |
109: --| 10/27/2008 vjavli FP Bug 7458643 fix:Standard cost update|
110: --| transaction should be displayed with |
111: --| correct cost(new cost minus prior cost)|
112: --| * primary_quantity (onhand qty at that |
113: --| moment). l_primary_qty := 0; |
115: --| (l_item_txn_info.new_cost - |
116: --| l_item_txn_info.prior_cost) * |
117: --| l_item_txn_info.primary_quantity; |
118: --| Get_Item_Txn_Info proc modified |
119: --|12/01/2008 vjavli Bug 7458643 fix: Standard cost Update |
120: --| found that primary_quantity is 0; |
121: --| We have to use quantity_adjusted |
122: --| Also, actual_cost will be NULL |
123: --| Even in Average Cost update, better to |
709: END IF;
710:
711: ELSIF l_item_txn_info.transaction_source_type_id = 11 AND
712: l_item_txn_info.transaction_action_id = 24 THEN
713: -- FP Bug#7458643 fix: Standard Cost Update transaction
714: l_primary_qty := 0; -- to avoid double counting of total quantity
715: l_total_cost := (l_item_txn_info.new_cost - l_item_txn_info.prior_cost) * l_item_txn_info.quantity_adjusted;
716: ELSE
717: -- all other transactions
771: -- =======================================================================
772: l_rpt_item_tbl_rec(l_index).txn_ini_qty := l_txn_init_qty;
773: -- Bug#3013597 fix: begin unit cost based on costing method of organization
774: IF p_primary_cost_method = 1 THEN
775: -- Standard costing organization
776: l_rpt_item_tbl_rec(l_index).txn_ini_unit_cost :=
777: l_item_txn_info.prior_Cost;
778: ELSE
779: -- Average 2, FIFO 5, LIFO 6 organizations
793: -- Final quantity for each transaction
794: -- ==================================================================
795: -- Total quantity including current transaction quantity
796: -- Total quantity = Begin qty + transaction quantity
797: -- For Standard Cost Update or Average Cost Update, primary_quantity
798: -- will be set to 0 in the earlier logic to avoid double counting
799: -- ==================================================================
800: l_rpt_item_tbl_rec(l_index).txn_fnl_qty :=
801: l_rpt_item_tbl_rec(l_index).txn_ini_qty +
805: -- Final Cost for each transaction
806: -- New Cost which is the final cost after processing current txn
807: -- =============================================================
808: IF p_primary_cost_method = 1 THEN
809: -- Standard costing organization
810: l_rpt_item_tbl_rec(l_index).txn_fnl_unit_cost :=
811: l_item_txn_info.New_Cost;
812: ELSE
813: -- Average 2, FIFO 5, LIFO 6 organizations
837: END IF;
838:
839: -- ===============================================================
840: -- Transaction Quantity and Transaction Cost of each transaction
841: -- Bug 7458643 fix: For Standard Cost Update - src_type_id is 11.
842: -- Average Cost Update - src_type_id is 13, l_primary_qty is zero.
843: -- For all other txns, l_primary_quantity has not null value.
844: -- ===============================================================
845: l_rpt_item_tbl_rec(l_index).txn_qty := l_primary_qty;
846:
847: -- ======================================================
848: -- Transaction Cost of each transaction
849: -- ======================================================
850: -- Bug 7458643 fix: standard cost update
851: -- transaction unit cost is diff of new_cost - prior_cost
852: -- for all other txns, actual_cost is a transaction cost
853: -- Note that for Average Cost Update txn, actual_cost will
854: -- have item adjustment cost.