eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1636: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE

1632: ,p_transaction_type_id IN NUMBER
1633: ,p_inventory_item_id IN NUMBER
1634: ,p_subinventory_code IN VARCHAR2
1635: ,p_locator_id IN NUMBER
1636: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE
1637: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE
1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS
1640: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';

Line 1637: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE

1633: ,p_inventory_item_id IN NUMBER
1634: ,p_subinventory_code IN VARCHAR2
1635: ,p_locator_id IN NUMBER
1636: ,p_mmli_rec IN mtl_transaction_lots_interface%ROWTYPE
1637: ,x_mmli_rec OUT NOCOPY mtl_transaction_lots_interface%ROWTYPE
1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS
1640: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';
1641: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 1642: l_mmli_rec mtl_transaction_lots_interface%ROWTYPE;

1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS
1640: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER_LOT';
1641: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1642: l_mmli_rec mtl_transaction_lots_interface%ROWTYPE;
1643: l_transaction_type_id NUMBER;
1644: l_inventory_item_id NUMBER;
1645: l_item VARCHAR2(100);
1646: l_type VARCHAR2(100);

Line 1722: INSERT INTO mtl_transaction_lots_interface

1718: || ':'
1719: || 'lot_qty is '
1720: || l_mmli_rec.transaction_quantity);
1721: END IF;
1722: INSERT INTO mtl_transaction_lots_interface
1723: (transaction_interface_id, last_update_date
1724: ,last_updated_by, last_update_login
1725: ,creation_date, created_by
1726: ,lot_number, transaction_quantity

Line 2019: -- construct mtl_transaction_lots_interface

2015: --x_mmti_rec.reservation_quantity := l_mmt_rec.reservation_quantity;
2016: -- x_mmti_rec.transaction_sequence_id := l_mmt_rec.transaction_sequence_id;
2017: --x_mmti_rec.transaction_reference := l_mmt_rec.transaction_reference;
2018:
2019: -- construct mtl_transaction_lots_interface
2020: IF (l_mmln_tbl.COUNT > 0) THEN
2021: FOR i IN 1 .. l_mmln_tbl.COUNT LOOP
2022: x_mmli_tbl (i).last_update_date :=
2023: l_mmln_tbl (i).last_update_date;

Line 2552: FROM mtl_transaction_lots_interface

2548:
2549: CURSOR cur_lot_input (v_trans_inter_id NUMBER)
2550: IS
2551: SELECT lot_number, SUM (transaction_quantity) l_mtli_lot_qty
2552: FROM mtl_transaction_lots_interface
2553: WHERE transaction_interface_id = v_trans_inter_id
2554: GROUP BY lot_number;
2555:
2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;

Line 2707: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP

2703: END IF;
2704:
2705: /* Bug 5358129 for ingredients lots should exist */
2706: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
2707: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP
2708: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,
2709: p_inventory_item_id => l_mmti_rec.inventory_item_id,
2710: p_lot_number => get_lots.lot_number,
2711: x_return_status => l_return_status);