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 2297: g_log_msg := 'Updating mtl_material_transactions table';

2293:
2294: --
2295: -- Update transaction valuation table
2296: --
2297: g_log_msg := 'Updating mtl_material_transactions table';
2298:
2299: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2300: THEN
2301: FND_LOG.STRING(

Line 2308: UPDATE mtl_material_transactions

2304: message => g_log_msg
2305: );
2306: END IF;
2307:
2308: UPDATE mtl_material_transactions
2309: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2310: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2311: , last_updated_by = g_user_id
2312: , last_update_login = g_login_id

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

2325: AND xpae.event_class_code NOT IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')
2326: )
2327: ;
2328:
2329: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
2330:
2331: print_debug(g_log_msg);
2332: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2333: THEN

Line 2353: g_log_msg := 'Updating receiving rows of subInv/Staging Transfers updated in mtl_material_transactions table';

2349: --
2350: -- 1. Update mmt table to set costed_flag on
2351: -- receiving side of SubInv/Staging Xfer transactions.
2352: --
2353: g_log_msg := 'Updating receiving rows of subInv/Staging Transfers updated in mtl_material_transactions table';
2354:
2355: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2356: THEN
2357: FND_LOG.STRING(

Line 2364: UPDATE mtl_material_transactions

2360: message => g_log_msg
2361: );
2362: END IF;
2363:
2364: UPDATE mtl_material_transactions
2365: SET opm_costed_flag = NULL
2366: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2367: , last_updated_by = g_user_id
2368: , last_update_login = g_login_id

Line 2387: g_log_msg := sql%rowcount || ' receiving rows of subInv/Staging Transfers updated in mtl_material_transactions table';

2383: AND xpae.event_class_code in ('SUBINV_XFER')
2384: )
2385: ;
2386:
2387: g_log_msg := sql%rowcount || ' receiving rows of subInv/Staging Transfers updated in mtl_material_transactions table';
2388:
2389: print_debug(g_log_msg);
2390: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2391: THEN

Line 2404: g_log_msg := 'Updating mtl_material_transactions table to set shipment_costed flag ' ||

2400: --
2401: -- 2. Update transaction valuation table to set shipment_costed flag
2402: -- to 'Y' for event clases FOB_RCPT_SENDER_RCPT and FOB_SHIP_RECIPIENT_SHIP
2403: --
2404: g_log_msg := 'Updating mtl_material_transactions table to set shipment_costed flag ' ||
2405: 'for event clases FOB_RCPT_SENDER_RCPT and FOB_SHIP_RECIPIENT_SHIP';
2406:
2407: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2408: THEN

Line 2416: UPDATE mtl_material_transactions

2412: message => g_log_msg
2413: );
2414: END IF;
2415:
2416: UPDATE mtl_material_transactions
2417: SET shipment_costed = 'Y'
2418: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2419: , last_updated_by = g_user_id
2420: , last_update_login = g_login_id

Line 2439: g_log_msg := sql%rowcount || ' rows of Inv Transfers updated to set shipment_costed flag to Y in mtl_material_transactions table';

2435: AND xpae.event_class_code in ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')
2436: )
2437: ;
2438:
2439: g_log_msg := sql%rowcount || ' rows of Inv Transfers updated to set shipment_costed flag to Y in mtl_material_transactions table';
2440:
2441: print_debug(g_log_msg);
2442: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2443: THEN

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

2632:
2633: --
2634: -- Update transaction valuation table
2635: --
2636: g_log_msg := 'Updating mtl_material_transactions table';
2637:
2638: print_debug(g_log_msg);
2639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2640: THEN

Line 2648: UPDATE mtl_material_transactions

2644: message => g_log_msg
2645: );
2646: END IF;
2647:
2648: UPDATE mtl_material_transactions
2649: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2650: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2651: , last_updated_by = g_user_id
2652: , last_update_login = g_login_id

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

2664: and xpae.event_class_code = gxem.event_class_code
2665: )
2666: ;
2667:
2668: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
2669:
2670: print_debug(g_log_msg);
2671: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2672: THEN

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

2951:
2952: --
2953: -- Update material transaction table
2954: --
2955: g_log_msg := 'Updating mtl_material_transactions table for batch material transactions';
2956:
2957: print_debug(g_log_msg);
2958: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2959: THEN

Line 2967: UPDATE mtl_material_transactions

2963: message => g_log_msg
2964: );
2965: END IF;
2966:
2967: UPDATE mtl_material_transactions
2968: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
2969: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
2970: , last_updated_by = g_user_id
2971: , last_update_login = g_login_id

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

2984: and xpae.event_class_code = gxem.event_class_code
2985: )
2986: ;
2987:
2988: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
2989:
2990: print_debug(g_log_msg);
2991: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
2992: THEN

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

3324:
3325: --
3326: -- Update transaction valuation table
3327: --
3328: g_log_msg := 'Updating mtl_material_transactions table';
3329:
3330: print_debug(g_log_msg);
3331: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3332: THEN

Line 3340: UPDATE mtl_material_transactions

3336: message => g_log_msg
3337: );
3338: END IF;
3339:
3340: UPDATE mtl_material_transactions
3341: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3342: , program_update_date = SYSDATE /* ANTHIYAG Updating Porgram_update_date instead of Last_update_date to avoid auditing issues */
3343: , last_updated_by = g_user_id
3344: , last_update_login = g_login_id

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

3356: and xpae.event_class_code = gxem.event_class_code
3357: )
3358: ;
3359:
3360: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
3361:
3362: print_debug(g_log_msg);
3363: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3364: THEN

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

3615: /*
3616: --
3617: -- Update transaction valuation table
3618: --
3619: g_log_msg := 'Updating mtl_material_transactions table';
3620:
3621: print_debug(g_log_msg);
3622: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3623: THEN

Line 3631: UPDATE mtl_material_transactions

3627: message => g_log_msg
3628: );
3629: END IF;
3630:
3631: UPDATE mtl_material_transactions
3632: SET opm_costed_flag = DECODE(G_accounting_mode, 'D', 'D', 'F', NULL)
3633: WHERE transaction_id
3634: in (SELECT
3635: xpae.SOURCE_ID_INT_1

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

3641: and xpae.event_class_code = gxem.event_class_code
3642: )
3643: ;
3644:
3645: g_log_msg := sql%rowcount || ' rows updated in mtl_material_transactions table';
3646:
3647: print_debug(g_log_msg);
3648: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
3649: THEN

Line 4003: FROM mtl_material_transactions

3999: (p_event_class_code = 'FOB_RCPT_SENDER_RCPT')
4000: THEN
4001: SELECT organization_id
4002: INTO l_security_id_int_1
4003: FROM mtl_material_transactions
4004: WHERE transaction_id = p_source_id_int_1;
4005: ELSE
4006: l_security_id_int_1 := p_security_id_int_1;
4007: END IF;

Line 4026: FROM mtl_material_transactions

4022: IF p_event_class_code = 'DELIVER'
4023: THEN
4024: SELECT rcv_transaction_id
4025: INTO l_source_id_int_1
4026: FROM mtl_material_transactions
4027: WHERE transaction_id = p_source_id_int_1
4028: ;
4029: ELSIF p_event_class_code = 'RECEIVE'
4030: THEN