DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 297: --* Modified Code in the Special Charges query to remove po_line_locations_all, changed the

293: --* Modified code in process_lot_split and process_lot_translate to correct the code pertaining to call of
294: --* merge_costs procedure and also to correct the value of total trans cost and unit cost being passed to the
295: --* create_material_transaction and create_lot_header procedures.
296: --* 14-Aug-2006 Anand Thiyagarajan Bug#5463200
297: --* Modified Code in the Special Charges query to remove po_line_locations_all, changed the
298: --* value for include_in_acquisition_cost to "I", used estimated_amount instead of actual
299: --* and included MMT table join with RCV_TRANSACTION_ID instead of INV_TRANSACTION_ID
300: --* 2-Aug-2007 Venkat Ch. Bug 6320304/5953977 - Non-recoverable taxes ME, as part of this
301: --* added unit of nonrecoverable tax to the unit cost in process_receipt().

Line 2650: --* Modified Code in the Special Charges query to remove po_line_locations_all, changed the*

2646: --* *
2647: --* HISTORY *
2648: --* *
2649: --* Bug#5463200 Anand Thiyagarajan 14-Aug-2006 *
2650: --* Modified Code in the Special Charges query to remove po_line_locations_all, changed the*
2651: --* value for include_in_acquisition_cost to "I", used estimated_amount instead of actual *
2652: --* and included MMT table join with RCV_TRANSACTION_ID instead of INV_TRANSACTION_ID *
2653: --* Andrea 4-Aug-2009 LCM-OPM Integrations, bug 8642337, added Unin all query to fetch *
2654: --* Estimated LC adjustments for LCM enabled Po lines. *

Line 2681: po_line_locations_all pll -- AF

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 */
2681: po_line_locations_all pll -- AF
2682: WHERE mmt.transaction_id = transaction_row.transaction_id /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2683: AND t.transaction_id = mmt.rcv_transaction_id
2684: AND t.shipment_header_id = rc.shipment_header_id
2685: AND t.shipment_line_id = rca.shipment_line_id

Line 2702: po_line_locations_all pll

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
2706: AND rt.transaction_id = glat.rcv_transaction_id