[Home] [Help]
223: --*
224: --* 06-Jan-2004 Dinesh Vadivel Bug# 4095937
225: --* The Lot Cost Process calculates the Exchg Rate as on the Receipt Header Date
226: --* whereas the Subledger uses the "Exchg Rate Date". Modified the Lot Actual Cost Process
227: --* to use the rcv_transactions.CURRENCY_CONVERSION_RATE as the Exchg Rate .
228: --* This is how we are doing in Actual Costing and Subledger Update
229: --*
230: --* 20-Jan-2005 Girish Jha Bug 4094132
231: --* We added a new filtering condition in the materials_cursor for handling reversals
2672: ,rc.cost_analysis_code
2673: ,nvl(rca.estimated_amount, rca.actual_amount)/mmt.transaction_quantity /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2674: ,uom.uom_code
2675: ,0 lcm_flag
2676: FROM rcv_transactions t,
2677: po_rcv_charges rc,
2678: po_rcv_charge_allocations rca,
2679: mtl_units_of_measure uom,
2680: mtl_material_transactions mmt, /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2697: ,1 lcm_flag
2698: FROM
2699: gmf_lc_adj_transactions glat,
2700: mtl_material_transactions mmt,
2701: rcv_transactions rt ,
2702: po_line_locations_all pll
2703: WHERE
2704: mmt.transaction_id = transaction_row.transaction_id
2705: AND glat.rcv_transaction_id = mmt.rcv_transaction_id
4180: --*
4181: --* 06-Jan-2004 Dinesh Vadivel Bug# 4095937
4182: --* The Lot Cost Process calculates the Exchg Rate as on the Receipt Header Date
4183: --* whereas the Subledger uses the "Exchg Rate Date". Modified the Lot Actual Cost Process
4184: --* to use the rcv_transactions.CURRENCY_CONVERSION_RATE as the Exchg Rate .
4185: --* 2-Aug-2007 Bug 6320304/5953977 - Non-recoverable taxes ME, as part of this added unit of
4186: --* nonrecoverable tax to the unit cost.
4187: --*
4188: --********************************************************************************************************
4188: --********************************************************************************************************
4189:
4190: PROCEDURE process_receipt
4191: IS
4192: document_code rcv_transactions.source_document_code%TYPE;
4193: source_orgn_id NUMBER;
4194: target_orgn_id NUMBER;
4195: source_le_id NUMBER;
4196: target_le_id NUMBER;
4208: END IF;
4209:
4210: -- The pointers in the inventory transaction link to the receipt as follows:
4211: -- DOC_ID is the SHIPMENT_HEADER_ID in rcv_shipment_headers
4212: -- LINE_ID is the TRANSACTION_ID in rcv_transactions
4213:
4214: -- From the row in rcv_transactions the po_unit_price (expressed in price_um so
4215: -- we need to convert it to item_um) is the source of the cost. There is also the
4216: -- received qty (expressed in recv_um so it might need converting too, although the
4210: -- The pointers in the inventory transaction link to the receipt as follows:
4211: -- DOC_ID is the SHIPMENT_HEADER_ID in rcv_shipment_headers
4212: -- LINE_ID is the TRANSACTION_ID in rcv_transactions
4213:
4214: -- From the row in rcv_transactions the po_unit_price (expressed in price_um so
4215: -- we need to convert it to item_um) is the source of the cost. There is also the
4216: -- received qty (expressed in recv_um so it might need converting too, although the
4217: -- OPM inventory transaction should have the number we need already). There are
4218: -- pointers in the receiving transaction to the po_header, po_line and the receipt
4246: receipt_uom,
4247: document_code,
4248: l_exchange_rate,
4249: l_rcv_transaction_id
4250: FROM rcv_transactions t, mtl_units_of_measure u, mtl_material_transactions mmt -- jboppana
4251: , po_distributions_all pda
4252: WHERE t.source_doc_unit_of_measure = u.unit_of_measure(+)
4253: AND t.transaction_id = mmt.rcv_transaction_id
4254: -- AND mmt.transaction_source_id = transaction_row.doc_id
4300: r.shipped_date
4301: INTO
4302: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
4303: FROM
4304: rcv_transactions t,
4305: mtl_material_transactions mmt,
4306: rcv_shipment_headers r,
4307: rcv_shipment_lines rsl,
4308: po_headers_all poh,
4338: r.shipped_date
4339: INTO
4340: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
4341: FROM
4342: rcv_transactions t,
4343: mtl_material_transactions mmt,
4344: rcv_shipment_headers r,
4345: rcv_shipment_lines rsl,
4346: po_headers_all poh,
7790: 0 as applied_amt, -- Bug 10159100
7791: mtln.primary_quantity as received_qty -- Bug 13906192
7792: FROM
7793: gmf_lc_adj_transactions glat,
7794: rcv_transactions rt,
7795: mtl_material_transactions mmt, -- Bug 13906192
7796: mtl_transaction_lot_numbers mtln -- Bug 13906192
7797: WHERE
7798: glat.adj_transaction_id = transaction_row.transaction_id
10691: -9 as oc3,
10692: 0 as routing_id
10693: FROM
10694: gmf_lc_adj_transactions glat, -- from import process of LCM
10695: rcv_transactions rt,
10696: mtl_material_transactions mmt, -- Bug 13906192
10697: mtl_transaction_lot_numbers mtln, -- Bug 13906192
10698: gmf_process_organizations_gt gpo,
10699: gmf_lot_costed_items_gt glci
11071: -9 as oc3,
11072: 0 as routing_id
11073: FROM
11074: gmf_lc_adj_transactions glat, -- from import process of LCM
11075: rcv_transactions rt,
11076: mtl_material_transactions mmt, -- Bug 13906192
11077: mtl_transaction_lot_numbers mtln, -- Bug 13906192
11078: gmf_process_organizations_gt gpo,
11079: gmf_lot_costed_items_gt glci