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_MATERIAL_TRANSACTIONS

Line 330: from mtl_material_transactions_temp

326: IF (g_debug <= gme_debug.g_log_statement) THEN
327: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
328: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
329: select count(*) into l_cnt_temp
330: from mtl_material_transactions_temp
331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
332: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
333: END IF;
334: IF l_ret < 0 THEN

Line 423: l_mmt_rec mtl_material_transactions%ROWTYPE;

419: ,x_return_status OUT NOCOPY VARCHAR2)
420: IS
421: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
422: l_transaction_id NUMBER;
423: l_mmt_rec mtl_material_transactions%ROWTYPE;
424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
425: l_mmti_rec mtl_transactions_interface%ROWTYPE;
426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
427: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 536: p_mmt_rec IN mtl_material_transactions%ROWTYPE

532: | Created 02-Feb-05 Pawan Kumar
533: |
534: +==========================================================================+ */
535: PROCEDURE update_material_txn (
536: p_mmt_rec IN mtl_material_transactions%ROWTYPE
537: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
538: ,x_return_status OUT NOCOPY VARCHAR2)
539: IS
540: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';

Line 542: l_mmt_rec mtl_material_transactions%ROWTYPE;

538: ,x_return_status OUT NOCOPY VARCHAR2)
539: IS
540: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
541: l_transaction_id NUMBER;
542: l_mmt_rec mtl_material_transactions%ROWTYPE;
543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
544: l_mmti_rec mtl_transactions_interface%ROWTYPE;
545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
546: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 701: l_mmt_rec mtl_material_transactions%ROWTYPE;

697:
698: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_TXN';
699: l_transaction_id NUMBER;
700: m_transaction_id NUMBER;
701: l_mmt_rec mtl_material_transactions%ROWTYPE;
702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
703: l_mmti_rec mtl_transactions_interface%ROWTYPE;
704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
705: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 1266: SELECT mtl_material_transactions_s.NEXTVAL

1262:
1263: l_mmti_rec := p_mmti_rec;
1264:
1265: IF gme_common_pvt.g_transaction_header_id IS NULL THEN
1266: SELECT mtl_material_transactions_s.NEXTVAL
1267: INTO gme_common_pvt.g_transaction_header_id
1268: FROM DUAL;
1269:
1270: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 1292: SELECT mtl_material_transactions_s.NEXTVAL

1288: || 'l_mmti_rec.transaction_header_id '
1289: || l_mmti_rec.transaction_header_id);
1290: END IF;
1291:
1292: SELECT mtl_material_transactions_s.NEXTVAL
1293: INTO l_mmti_rec.transaction_interface_id
1294: FROM DUAL;
1295:
1296: IF l_mmti_rec.transaction_type_id IN

Line 1822: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

1818: |
1819: +==========================================================================+ */
1820: PROCEDURE get_transactions (
1821: p_transaction_id IN NUMBER
1822: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
1823: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
1824: ,x_return_status OUT NOCOPY VARCHAR2)
1825: IS
1826:

Line 1835: FROM mtl_material_transactions mmt

1831:
1832: CURSOR cur_get_transaction (v_transaction_id NUMBER, v_reversal_type NUMBER)
1833: IS
1834: SELECT *
1835: FROM mtl_material_transactions mmt
1836: WHERE transaction_id = v_transaction_id
1837: AND NOT EXISTS ( SELECT /*+ no_unnest */
1838: transaction_id1
1839: FROM gme_transaction_pairs

Line 1963: p_mmt_rec IN mtl_material_transactions%ROWTYPE

1959: | Created 02-Feb-05 Pawan Kumar
1960: |
1961: +==========================================================================+ */
1962: PROCEDURE construct_mmti (
1963: p_mmt_rec IN mtl_material_transactions%ROWTYPE
1964: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1969: l_mmt_rec mtl_material_transactions%ROWTYPE;

1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;
1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1971: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1972: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1973: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';

Line 2099: FROM mtl_material_transactions mmt

2095: CURSOR cur_get_trans (v_mat_det_id NUMBER, v_batch_id NUMBER,
2096: v_txn_source_type NUMBER, v_pairs_reversal_type NUMBER)
2097: IS
2098: SELECT *
2099: FROM mtl_material_transactions mmt
2100: WHERE trx_source_line_id = v_mat_det_id
2101: AND transaction_source_id = v_batch_id
2102: AND transaction_source_type_id = v_txn_source_type
2103: AND NOT EXISTS ( SELECT /*+ no_unnest */

Line 2383: FROM mtl_material_transactions t, gme_material_details d

2379: NULL
2380: )
2381: )
2382: )
2383: FROM mtl_material_transactions t, gme_material_details d
2384: WHERE t.organization_id = v_organization_id
2385: AND t.inventory_item_id = v_item_id
2386: AND t.transaction_source_id = v_batch_id
2387: AND t.trx_source_line_id = v_mat_det_id

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 3610: FROM mtl_material_transactions_temp

3606:
3607: CURSOR get_error_temp
3608: IS
3609: SELECT ERROR_CODE, error_explanation
3610: FROM mtl_material_transactions_temp
3611: WHERE transaction_header_id =
3612: gme_common_pvt.g_transaction_header_id;
3613:
3614: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_TRANSACTIONS';

Line 3757: mtl_material_transactions mmt,

3753: , mmt.last_updated_by
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

Line 4574: | x_mmt_rec -- mtl_material_transactions rowtype

Line 4582: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

4578: |
4579: +==========================================================================+ */
4580: PROCEDURE get_mmt_transactions (
4581: p_transaction_id IN NUMBER
4582: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
4583: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
4584: ,x_return_status OUT NOCOPY VARCHAR2)
4585: IS
4586:

Line 4590: FROM mtl_material_transactions mmt

4586:
4587: CURSOR cur_get_transaction (v_transaction_id NUMBER)
4588: IS
4589: SELECT *
4590: FROM mtl_material_transactions mmt
4591: WHERE transaction_id = v_transaction_id;
4592:
4593: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
4594: IS