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.

[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on GME_TRANSACTION_PAIRS

Line 694: FROM gme_transaction_pairs

690: IS
691: CURSOR cur_get_ph_txns (v_transaction_id NUMBER)
692: IS
693: SELECT transaction_id2
694: FROM gme_transaction_pairs
695: WHERE transaction_id1 = v_transaction_id
696: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
697:
698: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_TXN';

Line 888: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables

884: || l_return_status);
885: END IF;
886:
887: -- Insert into gme_transactions_pairs table
888: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables
889: -- which column will carry the material detail ld
890: IF (g_debug <= gme_debug.g_log_statement) THEN
891: gme_debug.put_line ( g_pkg_name
892: || '.'

Line 918: INSERT INTO gme_transaction_pairs

914: || 'inserting into pairs table pair_type:'
915: || gme_common_pvt.g_pairs_reversal_type);
916: END IF;
917:
918: INSERT INTO gme_transaction_pairs
919: (batch_id, material_detail_id
920: ,transaction_id1, transaction_id2
921: ,pair_type)
922: VALUES (l_mat_dtl_rec.batch_id, l_mat_dtl_rec.material_detail_id

Line 1839: FROM gme_transaction_pairs

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
1840: WHERE transaction_id1 = mmt.transaction_id
1841: AND pair_type = v_reversal_type)
1842: ORDER BY mmt.transaction_quantity;
1843:

Line 2105: FROM gme_transaction_pairs

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 */
2104: transaction_id1
2105: FROM gme_transaction_pairs
2106: WHERE transaction_id1 = mmt.transaction_id
2107: AND pair_type = v_pairs_reversal_type)
2108: ORDER BY mmt.transaction_quantity;
2109:

Line 3017: l_gme_pairs_rec gme_transaction_pairs%ROWTYPE;

3013: l_source_line_id NUMBER;
3014: l_inventory_item_id NUMBER;
3015: l_organization_id NUMBER;
3016: l_actual_qty NUMBER;
3017: l_gme_pairs_rec gme_transaction_pairs%ROWTYPE;
3018: l_mat_dtl_rec gme_material_details%ROWTYPE;
3019: l_api_name CONSTANT VARCHAR2 (30) := 'gme_post_process';
3020: l_exists NUMBER; -- Bug 5763818
3021: transfer_error EXCEPTION; -- B4944024

Line 3107: UPDATE gme_transaction_pairs

3103: || l_source_line_id);
3104: END IF;
3105:
3106: -- UPDATE transactions pair table for the reversal transaction
3107: UPDATE gme_transaction_pairs
3108: SET transaction_id2 = l_transaction_id
3109: WHERE batch_id = l_transaction_source_id
3110: AND material_detail_id = l_trx_source_line_id
3111: AND transaction_id1 = l_source_line_id

Line 3114: INSERT INTO gme_transaction_pairs

3110: AND material_detail_id = l_trx_source_line_id
3111: AND transaction_id1 = l_source_line_id
3112: AND pair_type = gme_common_pvt.g_pairs_reversal_type;
3113: -- now insert a reverse record
3114: INSERT INTO gme_transaction_pairs
3115: (batch_id, material_detail_id
3116: ,transaction_id1, transaction_id2
3117: ,pair_type)
3118: VALUES (l_transaction_source_id, l_trx_source_line_id

Line 3174: UPDATE gme_transaction_pairs

3170: || '.'
3171: || 'update row-phantom in pairs with l_trans_ID: '
3172: || l_transaction_id);
3173: END IF;
3174: UPDATE gme_transaction_pairs
3175: SET transaction_id2 = l_transaction_id
3176: WHERE transaction_id2 = l_transaction_reference
3177: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3178:

Line 3182: FROM gme_transaction_pairs

3178:
3179: BEGIN
3180: SELECT *
3181: INTO l_gme_pairs_rec
3182: FROM gme_transaction_pairs
3183: WHERE transaction_id2 = l_transaction_id
3184: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3185:
3186: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 3228: INSERT INTO gme_transaction_pairs

3224: || 'insert row- after update -mat_det_id: '
3225: || l_trx_source_line_id);
3226: END IF; -- for debug
3227:
3228: INSERT INTO gme_transaction_pairs
3229: (batch_id, material_detail_id
3230: ,transaction_id1, transaction_id2
3231: ,pair_type)
3232: VALUES (l_transaction_source_id, l_trx_source_line_id

Line 3272: INSERT INTO gme_transaction_pairs

3268: || l_trx_source_line_id);
3269: END IF;
3270:
3271: --INSERT a new row
3272: INSERT INTO gme_transaction_pairs
3273: (batch_id, material_detail_id
3274: ,transaction_id1, transaction_id2
3275: ,pair_type)
3276: VALUES (l_transaction_source_id, l_trx_source_line_id

Line 3513: DELETE FROM gme_transaction_pairs

3509: || l_material_detail_id);
3510: END IF;
3511:
3512: IF l_batch_id IS NOT NULL THEN
3513: DELETE FROM gme_transaction_pairs
3514: WHERE batch_id = l_batch_id;
3515: ELSIF l_material_detail_id IS NOT NULL THEN
3516: DELETE FROM gme_transaction_pairs
3517: WHERE material_detail_id = l_material_detail_id;

Line 3516: DELETE FROM gme_transaction_pairs

3512: IF l_batch_id IS NOT NULL THEN
3513: DELETE FROM gme_transaction_pairs
3514: WHERE batch_id = l_batch_id;
3515: ELSIF l_material_detail_id IS NOT NULL THEN
3516: DELETE FROM gme_transaction_pairs
3517: WHERE material_detail_id = l_material_detail_id;
3518: ELSE
3519: DELETE FROM gme_transaction_pairs
3520: WHERE batch_id = l_batch_id

Line 3519: DELETE FROM gme_transaction_pairs

3515: ELSIF l_material_detail_id IS NOT NULL THEN
3516: DELETE FROM gme_transaction_pairs
3517: WHERE material_detail_id = l_material_detail_id;
3518: ELSE
3519: DELETE FROM gme_transaction_pairs
3520: WHERE batch_id = l_batch_id
3521: AND material_detail_id = l_material_detail_id;
3522: END IF;
3523:

Line 3761: gme_transaction_pairs gtp

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
3763: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id
3764: AND mtln.transaction_id(+) = mmt.transaction_id
3765: AND msi.organization_id = mmt.organization_id

Line 4566: | this procedure does not check for enteries in gme_transaction_pairs