APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 2635: FROM mtl_transaction_lot_numbers

2631:
2632: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
2633: IS
2634: SELECT *
2635: FROM mtl_transaction_lot_numbers
2636: WHERE transaction_id = v_transaction_id;
2637:
2638: l_api_name CONSTANT VARCHAR2 (30) := 'GET_TRANSACTIONS';
2639: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 3028: FROM mtl_transaction_lot_numbers

3024: IS
3025: CURSOR cur_get_lot_trans (v_transaction_id NUMBER)
3026: IS
3027: SELECT *
3028: FROM mtl_transaction_lot_numbers
3029: WHERE transaction_id = v_transaction_id;
3030:
3031: l_api_name CONSTANT VARCHAR2 (30) := 'GET_LOT_TRANS';
3032: BEGIN

Line 3265: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l, gme_material_details d

3261: NULL
3262: )
3263: )
3264: )
3265: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l, gme_material_details d
3266: WHERE l.transaction_id = m.transaction_id
3267: AND m.trx_source_line_id = d.material_detail_id
3268: AND l.lot_number = v_lot_number
3269: AND l.inventory_item_id = v_item_id

Line 3812: FROM mtl_material_transactions t, mtl_transaction_lot_numbers l

3808: SELECT t.transaction_id, t.transaction_source_id, l.lot_number
3809: ,t.trx_source_line_id, t.source_line_id, t.transaction_type_id,
3810: t.transaction_reference, t.inventory_item_id
3811: , t.organization_id ,t.transaction_quantity
3812: FROM mtl_material_transactions t, mtl_transaction_lot_numbers l
3813: WHERE t.transaction_id = l.transaction_id(+)
3814: AND t.transaction_id = v_transaction_id;
3815: /* Bug 5903208 Modified cursor so it gets 1 lot at a time for GMF needs */
3816: CURSOR cur_mat_sum(v_organization_id IN NUMBER

Line 3825: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl

3821: DECODE(d.dtl_um,t.transaction_uom, NVL(tl.transaction_quantity,t.transaction_quantity),
3822: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5
3823: ,NVL(tl.transaction_quantity,t.transaction_quantity), t.transaction_uom
3824: ,d.dtl_um, NULL, NULL)) doc_qty
3825: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
3826: WHERE t.organization_id = v_organization_id
3827: AND t.transaction_source_id = v_batch_id
3828: AND t.trx_source_line_id = v_mat_det_id
3829: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type

Line 3841: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l

3837: ,v_batch_id IN NUMBER
3838: ,v_mat_det_id IN NUMBER)
3839: IS
3840: SELECT lot_number, SUM (l.transaction_quantity)
3841: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l
3842: WHERE l.transaction_id = m.transaction_id
3843: AND l.lot_number = v_lot_number
3844: AND l.inventory_item_id = v_item_id
3845: AND l.organization_id = v_organization_id

Line 4745: --mtl_transaction_lot_numbers mtln,

4741: , mmt.created_by
4742: , mmt.last_update_login
4743: FROM
4744: --mtl_material_transactions mmt,
4745: --mtl_transaction_lot_numbers mtln,
4746: mtl_material_transactions mmt, /* Removed mtln for Bug 8347011 base bug 8219507 */
4747: mtl_system_items_b msi,
4748: gme_material_details md,
4749: gme_transaction_pairs gtp

Line 5638: FROM mtl_transaction_lot_numbers

5634:
5635: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
5636: IS
5637: SELECT *
5638: FROM mtl_transaction_lot_numbers
5639: WHERE transaction_id = v_transaction_id;
5640:
5641: l_api_name CONSTANT VARCHAR2 (30) := 'GET_MMT_TRANSACTIONS';
5642: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;