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 481: from mtl_material_transactions_temp

477: IF (g_debug <= gme_debug.g_log_statement) THEN
478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp
482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
484: END IF;
485: IF l_ret < 0 THEN

Line 667: l_mmt_rec mtl_material_transactions%ROWTYPE;

663: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
664: ,x_return_status OUT NOCOPY VARCHAR2)
665: IS
666: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
667: l_mmt_rec mtl_material_transactions%ROWTYPE;
668: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
669: l_mmti_rec mtl_transactions_interface%ROWTYPE;
670: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
671: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 681: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i

677: -- Bug 9301755 - Introduce cursor to get line_type and variables.
678: -- Bug 9770408 - Fetch the divisible flag also.
679: CURSOR Cur_get_material_line_type (v_transaction_id NUMBER) IS
680: SELECT d.line_type, NVL( lot_divisible_flag, 'Y')
681: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i
682: WHERE t.transaction_source_type_id = 5
683: AND t.transaction_id = v_transaction_id
684: AND d.batch_id = t.transaction_source_id
685: AND d.material_detail_id = t.trx_source_line_id

Line 869: p_mmt_rec IN mtl_material_transactions%ROWTYPE

865: | of 7385309 which dealt with product yields only. This keeps that fix
866: | in place for products and byproducts.
867: +==========================================================================+ */
868: PROCEDURE update_material_txn (
869: p_mmt_rec IN mtl_material_transactions%ROWTYPE
870: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
871: ,x_return_status OUT NOCOPY VARCHAR2)
872: IS
873: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';

Line 875: l_mmt_rec mtl_material_transactions%ROWTYPE;

871: ,x_return_status OUT NOCOPY VARCHAR2)
872: IS
873: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
874: l_transaction_id NUMBER;
875: l_mmt_rec mtl_material_transactions%ROWTYPE;
876: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
877: l_mmti_rec mtl_transactions_interface%ROWTYPE;
878: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
879: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 887: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i

883:
884: -- Bug 8639523 - Introduce cursor to get line_type and variables.
885: CURSOR Cur_get_material_line_type (v_transaction_id NUMBER) IS
886: SELECT d.line_type, NVL( lot_divisible_flag, 'Y')
887: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i
888: WHERE t.transaction_source_type_id = 5
889: AND t.transaction_id = v_transaction_id
890: AND d.batch_id = t.transaction_source_id
891: AND d.material_detail_id = t.trx_source_line_id

Line 1117: l_mmt_rec mtl_material_transactions%ROWTYPE;

1113:
1114: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_TXN';
1115: l_transaction_id NUMBER;
1116: m_transaction_id NUMBER;
1117: l_mmt_rec mtl_material_transactions%ROWTYPE;
1118: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1119: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1120: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1121: l_mat_dtl_rec gme_material_details%ROWTYPE;

Line 1914: SELECT mtl_material_transactions_s.NEXTVAL

1910:
1911: l_mmti_rec := p_mmti_rec;
1912:
1913: IF gme_common_pvt.g_transaction_header_id IS NULL THEN
1914: SELECT mtl_material_transactions_s.NEXTVAL
1915: INTO gme_common_pvt.g_transaction_header_id
1916: FROM DUAL;
1917:
1918: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 1940: SELECT mtl_material_transactions_s.NEXTVAL

1936: || 'l_mmti_rec.transaction_header_id '
1937: || l_mmti_rec.transaction_header_id);
1938: END IF;
1939:
1940: SELECT mtl_material_transactions_s.NEXTVAL
1941: INTO l_mmti_rec.transaction_interface_id
1942: FROM DUAL;
1943:
1944: IF l_mmti_rec.transaction_type_id IN

Line 2610: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

2606: |
2607: +==========================================================================+ */
2608: PROCEDURE get_transactions (
2609: p_transaction_id IN NUMBER
2610: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
2611: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
2612: ,x_return_status OUT NOCOPY VARCHAR2)
2613: IS
2614:

Line 2623: FROM mtl_material_transactions mmt

2619:
2620: CURSOR cur_get_transaction (v_transaction_id NUMBER, v_reversal_type NUMBER)
2621: IS
2622: SELECT *
2623: FROM mtl_material_transactions mmt
2624: WHERE transaction_id = v_transaction_id
2625: AND NOT EXISTS ( SELECT /*+ no_unnest */
2626: transaction_id1
2627: FROM gme_transaction_pairs

Line 2751: p_mmt_rec IN mtl_material_transactions%ROWTYPE

2747: | Created 02-Feb-05 Pawan Kumar
2748: |
2749: +==========================================================================+ */
2750: PROCEDURE construct_mmti (
2751: p_mmt_rec IN mtl_material_transactions%ROWTYPE
2752: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
2753: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
2754: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
2755: ,x_return_status OUT NOCOPY VARCHAR2)

Line 2757: l_mmt_rec mtl_material_transactions%ROWTYPE;

2753: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
2754: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
2755: ,x_return_status OUT NOCOPY VARCHAR2)
2756: IS
2757: l_mmt_rec mtl_material_transactions%ROWTYPE;
2758: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2759: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2760: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2761: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';

Line 2895: FROM mtl_material_transactions mmt

2891: CURSOR cur_get_trans (v_mat_det_id NUMBER, v_batch_id NUMBER,
2892: v_txn_source_type NUMBER, v_pairs_reversal_type NUMBER)
2893: IS
2894: SELECT *
2895: FROM mtl_material_transactions mmt
2896: WHERE trx_source_line_id = v_mat_det_id
2897: AND transaction_source_id = v_batch_id
2898: AND transaction_source_type_id = v_txn_source_type
2899: AND NOT EXISTS ( SELECT /*+ no_unnest */

Line 2917: FROM mtl_material_transactions mmt

2913: IS
2914:
2915: SELECT * FROM
2916: ( SELECT *
2917: FROM mtl_material_transactions mmt
2918: WHERE trx_source_line_id = v_mat_det_id
2919: AND transaction_source_id = v_batch_id
2920: AND transaction_source_type_id = v_txn_source_type
2921: AND NOT EXISTS ( SELECT /*+ no_unnest */

Line 2930: FROM mtl_material_transactions mmt

2926:
2927: UNION ALL
2928:
2929: SELECT *
2930: FROM mtl_material_transactions mmt
2931: WHERE trx_source_line_id = v_phantom_line_id
2932: AND transaction_source_id = v_phantom_batch_id
2933: AND transaction_source_type_id = v_txn_source_type
2934: AND NOT EXISTS ( SELECT /*+ no_unnest */

Line 3231: FROM mtl_material_transactions t, gme_material_details d

3227: NULL
3228: )
3229: )
3230: )
3231: FROM mtl_material_transactions t, gme_material_details d
3232: WHERE t.organization_id = v_organization_id
3233: AND t.inventory_item_id = v_item_id
3234: AND t.transaction_source_id = v_batch_id
3235: AND t.trx_source_line_id = v_mat_det_id

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 4044: FROM mtl_material_transactions t

4040: and with the qty and opposite sign */
4041: FOR l_gme_pairs_rec_upd in (select * from gme_transaction_pairs where transaction_id2 = l_transaction_reference)
4042: LOOP
4043: SELECT transaction_quantity INTO l_transaction_quantity_upd
4044: FROM mtl_material_transactions t
4045: WHERE t.transaction_id = l_gme_pairs_rec_upd.transaction_id1;
4046:
4047: IF (l_transaction_quantity_upd = (-1) *l_transaction_quantity )AND
4048: (l_mat_dtl_rec.phantom_line_id = l_gme_pairs_rec_upd.material_detail_id) THEN

Line 4506: FROM mtl_material_transactions_temp

4502:
4503: CURSOR get_error_temp
4504: IS
4505: SELECT ERROR_CODE, error_explanation
4506: FROM mtl_material_transactions_temp
4507: WHERE transaction_header_id =gme_common_pvt.g_transaction_header_id
4508: AND error_explanation IS NOT NULL;
4509:
4510: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_TRANSACTIONS';

Line 4535: FROM mtl_material_transactions_temp

4531: Select sum(cnt)
4532: INTO int_rec_count
4533: FROM (
4534: SELECT COUNT (*) cnt
4535: FROM mtl_material_transactions_temp
4536: WHERE transaction_header_id = p_header_id
4537: AND process_flag = 'Y'
4538: UNION ALL
4539: SELECT COUNT (*) cnt

Line 4602: FROM mtl_material_transactions_temp

4598: -- Bug 14297117. Update the Supplier lot number
4599: IF (p_table = 2) THEN
4600: FOR mmtt_rec_cur in
4601: (SELECT transaction_temp_id, inventory_item_id, organization_id
4602: FROM mtl_material_transactions_temp
4603: WHERE transaction_header_id = p_header_id
4604: AND process_flag = 'Y') LOOP
4605: UPDATE mtl_transaction_lots_temp mtlt
4606: SET (grade_code, supplier_lot_number) =

Line 4744: --mtl_material_transactions mmt,

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

Line 4746: mtl_material_transactions mmt, /* Removed mtln for Bug 8347011 base bug 8219507 */

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
4750: WHERE

Line 5616: | x_mmt_rec -- mtl_material_transactions rowtype

Line 5624: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE

5620: |
5621: +==========================================================================+ */
5622: PROCEDURE get_mmt_transactions (
5623: p_transaction_id IN NUMBER
5624: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
5625: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
5626: ,x_return_status OUT NOCOPY VARCHAR2)
5627: IS
5628:

Line 5632: FROM mtl_material_transactions mmt

5628:
5629: CURSOR cur_get_transaction (v_transaction_id NUMBER)
5630: IS
5631: SELECT *
5632: FROM mtl_material_transactions mmt
5633: WHERE transaction_id = v_transaction_id;
5634:
5635: CURSOR cur_get_lot_transaction (v_transaction_id NUMBER)
5636: IS