APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1847: FROM mtl_transaction_lot_numbers

1843:
1844: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
1845: IS
1846: SELECT *
1847: FROM mtl_transaction_lot_numbers
1848: WHERE transaction_id = v_transaction_id;
1849:
1850: l_api_name CONSTANT VARCHAR2 (30) := 'GET_TRANSACTIONS';
1851: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 2180: FROM mtl_transaction_lot_numbers

2176: IS
2177: CURSOR cur_get_lot_trans (v_transaction_id NUMBER)
2178: IS
2179: SELECT *
2180: FROM mtl_transaction_lot_numbers
2181: WHERE transaction_id = v_transaction_id;
2182:
2183: l_api_name CONSTANT VARCHAR2 (30) := 'GET_LOT_TRANS';
2184: BEGIN

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

2411: NULL
2412: )
2413: )
2414: )
2415: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l, gme_material_details d
2416: WHERE l.transaction_id = m.transaction_id
2417: AND m.trx_source_line_id = d.material_detail_id
2418: AND l.lot_number = v_lot_number
2419: AND l.inventory_item_id = v_item_id

Line 2953: FROM mtl_material_transactions t, mtl_transaction_lot_numbers l

2949: SELECT t.transaction_id, t.transaction_source_id, l.lot_number
2950: ,t.trx_source_line_id, t.source_line_id, t.transaction_type_id,
2951: t.transaction_reference, t.inventory_item_id
2952: , t.organization_id
2953: FROM mtl_material_transactions t, mtl_transaction_lot_numbers l
2954: WHERE t.transaction_id = l.transaction_id(+)
2955: AND t.transaction_id = v_transaction_id;
2956: /* Bug 5903208 Modified cursor so it gets 1 lot at a time for GMF needs */
2957: CURSOR cur_mat_sum(v_organization_id IN NUMBER

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

2962: DECODE(d.dtl_um,t.transaction_uom, NVL(tl.transaction_quantity,t.transaction_quantity),
2963: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5
2964: ,NVL(tl.transaction_quantity,t.transaction_quantity), t.transaction_uom
2965: ,d.dtl_um, NULL, NULL)) doc_qty
2966: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
2967: WHERE t.organization_id = v_organization_id
2968: AND t.transaction_source_id = v_batch_id
2969: AND t.trx_source_line_id = v_mat_det_id
2970: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type

Line 2982: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l

2978: ,v_batch_id IN NUMBER
2979: ,v_mat_det_id IN NUMBER)
2980: IS
2981: SELECT lot_number, SUM (l.transaction_quantity)
2982: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l
2983: WHERE l.transaction_id = m.transaction_id
2984: AND l.lot_number = v_lot_number
2985: AND l.inventory_item_id = v_item_id
2986: AND l.organization_id = v_organization_id

Line 3758: mtl_transaction_lot_numbers mtln,

3754: , mmt.created_by
3755: , mmt.last_update_login
3756: FROM
3757: mtl_material_transactions mmt,
3758: mtl_transaction_lot_numbers mtln,
3759: mtl_system_items_b msi,
3760: gme_material_details md,
3761: gme_transaction_pairs gtp
3762: WHERE

Line 4596: FROM mtl_transaction_lot_numbers

4592:
4593: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
4594: IS
4595: SELECT *
4596: FROM mtl_transaction_lot_numbers
4597: WHERE transaction_id = v_transaction_id;
4598:
4599: l_api_name CONSTANT VARCHAR2 (30) := 'GET_MMT_TRANSACTIONS';
4600: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;