APPS.CST_MGD_MSTR_BOOK_RPT dependencies on STANDARD

Line 89: --| type is Standard then Begin Unit Cost |

85: --| order by trunc(transaction_date), |
86: --| transaction_id bug#3002073 fix |
87: --| 06/22/2003 vjavli Bug#3013597 fix: cost type of the |
88: --| organization is to be verified. If cost|
89: --| type is Standard then Begin Unit Cost |
90: --| will be actual cost of very first txn |
91: --| and End Unit Cost will be actual cost |
92: --| of last txn. If Cost Type is Average, |
93: --| LIFO, FIFO then Begin Unit Cost will be|

Line 120: --| 10/27/2008 vjavli FP Bug 7458643 fix:Standard cost update|

116: --| CST_MGD_MSTR_BOOK_TEMP |
117: --| 02/24/2006 vmutyala Bug # 4912772 Performance issue in the |
118: --| dynamic query in Create_Inv_Msbk_Rpt is|
119: --| resolved by restructuring the query |
120: --| 10/27/2008 vjavli FP Bug 7458643 fix:Standard cost update|
121: --| transaction should be displayed with |
122: --| correct cost(new cost minus prior cost)|
123: --| * primary_quantity (onhand qty at that |
124: --| moment). l_primary_qty := 0; |

Line 130: --|12/01/2008 vjavli Bug 7458643 fix: Standard cost Update |

126: --| (l_item_txn_info.new_cost - |
127: --| l_item_txn_info.prior_cost) * |
128: --| l_item_txn_info.primary_quantity; |
129: --| get_item_txn_info proc modified |
130: --|12/01/2008 vjavli Bug 7458643 fix: Standard cost Update |
131: --| found that primary_quantity is 0; |
132: --| We have to use quantity_adjusted |
133: --| Also, actual_cost will be NULL |
134: --| Even in Average Cost update, better to |

Line 2325: -- FP Bug#7458643 fix: Standard Cost Update transaction

2321: END IF;
2322:
2323: ELSIF l_item_txn_info.transaction_source_type_id = 11 AND
2324: l_item_txn_info.transaction_action_id = 24 THEN
2325: -- FP Bug#7458643 fix: Standard Cost Update transaction
2326: l_primary_qty := 0; -- to avoid double counting of total quantity
2327: l_total_cost := (l_item_txn_info.new_cost - l_item_txn_info.prior_cost) * l_item_txn_info.quantity_adjusted;
2328: ELSE
2329: -- all other transactions

Line 2388: -- Standard costing organization

2384: -- =======================================================================
2385: l_rpt_item_tbl_rec(l_index).txn_ini_qty := l_txn_init_qty;
2386: -- Bug#3013597 fix: begin unit cost based on costing method of organization
2387: IF p_primary_cost_method = 1 THEN
2388: -- Standard costing organization
2389: l_rpt_item_tbl_rec(l_index).txn_ini_unit_cost :=
2390: l_item_txn_info.prior_Cost;
2391: ELSE
2392: -- Average 2, FIFO 5, LIFO 6 organizations

Line 2410: -- For Standard Cost Update or Average Cost Update, primary_quantity

2406: -- Final quantity for each transaction
2407: -- ==================================================================
2408: -- Total quantity including current transaction quantity
2409: -- Total quantity = Begin qty + transaction quantity
2410: -- For Standard Cost Update or Average Cost Update, primary_quantity
2411: -- will be set to 0 in the earlier logic to avoid double counting
2412: -- ==================================================================
2413: l_rpt_item_tbl_rec(l_index).txn_fnl_qty :=
2414: l_rpt_item_tbl_rec(l_index).txn_ini_qty +

Line 2422: -- Standard costing organization

2418: -- Final Cost for each transaction
2419: -- New Cost which is the final cost after processing current txn
2420: -- =============================================================
2421: IF p_primary_cost_method = 1 THEN
2422: -- Standard costing organization
2423: l_rpt_item_tbl_rec(l_index).txn_fnl_unit_cost :=
2424: l_item_txn_info.New_Cost;
2425: ELSE
2426: -- Average 2, FIFO 5, LIFO 6 organizations

Line 2454: -- Bug 7458643 fix: For Standard Cost Update - src_type_id is 11.

2450: END IF;
2451:
2452: -- ===============================================================
2453: -- Transaction Quantity and Transaction Cost of each transaction
2454: -- Bug 7458643 fix: For Standard Cost Update - src_type_id is 11.
2455: -- Average Cost Update - src_type_id is 13, l_primary_qty is zero.
2456: -- For all other txns, l_primary_quantity has not null value.
2457: -- ===============================================================
2458: l_rpt_item_tbl_rec(l_index).txn_qty := l_primary_qty;

Line 2463: -- Bug 7458643 fix: standard cost update

2459:
2460: -- ======================================================
2461: -- Transaction Cost of each transaction
2462: -- ======================================================
2463: -- Bug 7458643 fix: standard cost update
2464: -- transaction unit cost is diff of new_cost - prior_cost
2465: -- for all other txns, actual_cost is a transaction cost
2466: -- Note that for Average Cost Update txn, actual_cost will
2467: -- have item adjustment cost.