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.GMF_XLA_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2524: g_log_msg := 'Updating mtl_material_transactions table';

2520:
2521: --
2522: -- Update transaction valuation table
2523: --
2524: g_log_msg := 'Updating mtl_material_transactions table';
2525:
2526: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2527: THEN
2528: FND_LOG.STRING(

Line 2534: -- We need to do a single update to mtl_material_transactions so that

2530: module => g_module_name || l_procedure_name,
2531: message => g_log_msg
2532: );
2533: END IF;
2534: -- We need to do a single update to mtl_material_transactions so that
2535: -- session will perform all updates together. If any other session has updated any of the records session will wait
2536: -- until lock is available eliminating dead lock.
2537: -- Old queries PK Bug 9066162. These queries are now used to insert data in gmf_inv_Txn_flags_gt
2538: -- Q1

Line 2539: /* UPDATE mtl_material_transactions

2535: -- session will perform all updates together. If any other session has updated any of the records session will wait
2536: -- until lock is available eliminating dead lock.
2537: -- Old queries PK Bug 9066162. These queries are now used to insert data in gmf_inv_Txn_flags_gt
2538: -- Q1
2539: /* UPDATE mtl_material_transactions
2540: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2541: , program_update_date = SYSDATE
2542: , last_updated_by = g_user_id
2543: , last_update_login = g_login_id

Line 2558: /* UPDATE mtl_material_transactions

2554: gxem.process_category = G_inventory_transactions
2555: AND xpae.event_class_code = gxem.event_class_code
2556: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP') ); */
2557: -- Q2 performed only when G_accounting_mode = 'F'
2558: /* UPDATE mtl_material_transactions
2559: SET opm_costed_flag = NULL
2560: , program_update_date = SYSDATE
2561: , last_updated_by = g_user_id
2562: , last_update_login = g_login_id

Line 2579: /* UPDATE mtl_material_transactions

2575: gxem.process_category = G_inventory_transactions
2576: AND xpae.event_class_code = gxem.event_class_code
2577: AND xpae.event_class_code in ('SUBINV_XFER')); */
2578: -- Q3 performed only when G_accounting_mode = 'F'
2579: /* UPDATE mtl_material_transactions
2580: SET shipment_costed = 'Y'
2581: , program_update_date = SYSDATE
2582: , last_updated_by = g_user_id
2583: , last_update_login = g_login_id

Line 2620: FROM mtl_material_transactions mmt1

2616: AND xpae.event_class_code = gxem.event_class_code
2617: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')
2618: UNION ALL
2619: SELECT DISTINCT mmt1.transfer_transaction_id, NULL, NULL
2620: FROM mtl_material_transactions mmt1
2621: WHERE G_accounting_mode = 'F'
2622: AND mmt1.transaction_source_type_id in (2, 4, 8, 9, 10, 13)
2623: AND mmt1.transaction_action_id in (2, 28)
2624: AND mmt1.transaction_id IN

Line 2634: FROM mtl_material_transactions mmt2

2630: AND xpae.event_class_code in ('SUBINV_XFER')
2631: )
2632: UNION ALL
2633: SELECT DISTINCT mmt2.transaction_id, 'N', 'Y'
2634: FROM mtl_material_transactions mmt2
2635: WHERE G_accounting_mode = 'F'
2636: AND mmt2.transaction_source_type_id in (7, 8, 13)
2637: AND mmt2.transaction_action_id in (12, 21)
2638: AND mmt2.transaction_id IN

Line 2675: update mtl_material_transactions mmt

2671: -- If any transaction/s are updated by another session this will wait, replacing possible deadlock with a wait event.
2672: -- Now Update mmt flags. We do not want to overwrite flags if written by another session Thus decode is used in select query.
2673: -- for both opm_costed_flag and shipment_costed.
2674:
2675: update mtl_material_transactions mmt
2676: set (opm_costed_flag, shipment_costed) = (select decode(mmt.opm_costed_flag,NULL,NULL,'D',decode(txngt.opm_costed_flag, NULL, NULL,'D'),'N',txngt.opm_costed_flag)
2677: ,decode(mmt.shipment_costed,'Y','Y',decode(txngt.shipment_costed,NULL,NULL,txngt.shipment_costed))
2678: from gmf_inv_Txn_flags_gt txngt
2679: where mmt.transaction_id = txngt.transaction_id)

Line 2690: g_log_msg := sql%rowcount || ' rows of Inv Transactions updated to set OPM_costed_flag and shipment_costed flag in mtl_material_transactions table';

2686: , request_id = g_request_id
2687: where transaction_id IN (select txngt.transaction_id from gmf_inv_Txn_flags_gt txngt);
2688:
2689:
2690: g_log_msg := sql%rowcount || ' rows of Inv Transactions updated to set OPM_costed_flag and shipment_costed flag in mtl_material_transactions table';
2691:
2692: print_debug(g_log_msg);
2693: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2694: THEN

Line 2911: g_log_msg := 'Updating mtl_material_transactions table';

2907:
2908: --
2909: -- Update transaction valuation table
2910: --
2911: g_log_msg := 'Updating mtl_material_transactions table';
2912:
2913: print_debug(g_log_msg);
2914: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2915: THEN

Line 2923: UPDATE mtl_material_transactions

2919: message => g_log_msg
2920: );
2921: END IF;
2922:
2923: UPDATE mtl_material_transactions
2924: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2925: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2926: /* Vpedarla bug: 9292668 commenting last_updated_by and last_update_login update*/
2927: -- , last_updated_by = g_user_id

Line 2946: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';

2942: and gxem.transaction_source_type_id <> 999
2943: )
2944: ;
2945:
2946: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
2947:
2948: print_debug(g_log_msg);
2949: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2950: THEN

Line 3356: g_log_msg := 'Updating mtl_material_transactions table for batch material transactions';

3352:
3353: --
3354: -- Update material transaction table
3355: --
3356: g_log_msg := 'Updating mtl_material_transactions table for batch material transactions';
3357:
3358: print_debug(g_log_msg);
3359: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3360: THEN

Line 3368: UPDATE mtl_material_transactions

3364: message => g_log_msg
3365: );
3366: END IF;
3367:
3368: UPDATE mtl_material_transactions
3369: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3370: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
3371: /* Vpedarla bug: 9292668 commenting last_updated_by and last_update_login update*/
3372: -- , last_updated_by = g_user_id

Line 3390: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';

3386: and xpae.event_class_code = gxem.event_class_code
3387: )
3388: ;
3389:
3390: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
3391:
3392: print_debug(g_log_msg);
3393: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3394: THEN

Line 3730: g_log_msg := 'Updating mtl_material_transactions table';

3726:
3727: --
3728: -- Update transaction valuation table
3729: --
3730: g_log_msg := 'Updating mtl_material_transactions table';
3731:
3732: print_debug(g_log_msg);
3733: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3734: THEN

Line 3742: UPDATE mtl_material_transactions

3738: message => g_log_msg
3739: );
3740: END IF;
3741:
3742: UPDATE mtl_material_transactions
3743: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3744: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
3745: /* Vpedarla bug: 9292668 commenting last_updated_by and last_update_login update*/
3746: -- , last_updated_by = g_user_id

Line 3763: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';

3759: and xpae.event_class_code = gxem.event_class_code
3760: )
3761: ;
3762:
3763: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
3764:
3765: print_debug(g_log_msg);
3766: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3767: THEN

Line 4022: g_log_msg := 'Updating mtl_material_transactions table';

4018: /*
4019: --
4020: -- Update transaction valuation table
4021: --
4022: g_log_msg := 'Updating mtl_material_transactions table';
4023:
4024: print_debug(g_log_msg);
4025: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
4026: THEN

Line 4034: UPDATE mtl_material_transactions

4030: message => g_log_msg
4031: );
4032: END IF;
4033:
4034: UPDATE mtl_material_transactions
4035: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
4036: WHERE transaction_id
4037: in (SELECT
4038: xpae.SOURCE_ID_INT_1

Line 4048: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';

4044: and xpae.event_class_code = gxem.event_class_code
4045: )
4046: ;
4047:
4048: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
4049:
4050: print_debug(g_log_msg);
4051: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
4052: THEN

Line 4411: FROM mtl_material_transactions

4407: (p_event_class_code = 'FOB_RCPT_SENDER_RCPT')
4408: THEN
4409: SELECT organization_id
4410: INTO l_security_id_int_1
4411: FROM mtl_material_transactions
4412: WHERE transaction_id = p_source_id_int_1;
4413: ELSE
4414: l_security_id_int_1 := p_security_id_int_1;
4415: END IF;

Line 4434: FROM mtl_material_transactions

4430: IF p_event_class_code = 'DELIVER'
4431: THEN
4432: SELECT rcv_transaction_id
4433: INTO l_source_id_int_1
4434: FROM mtl_material_transactions
4435: WHERE transaction_id = p_source_id_int_1
4436: ;
4437: ELSIF p_event_class_code = 'RECEIVE'
4438: THEN