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

Line 2335: , mtl_material_transactions mmt

2331: , NVL(ratl.quantity_invoiced,l_movement_transaction.transaction_quantity)
2332: FROM
2333: RA_CUSTOMER_TRX_ALL rat
2334: , RA_CUSTOMER_TRX_LINES_ALL ratl
2335: , mtl_material_transactions mmt
2336: WHERE rat.customer_trx_id = ratl.customer_trx_id
2337: AND ratl.line_type = 'LINE'
2338: AND ratl.sales_order = to_char(l_movement_transaction.order_number)
2339: AND ratl.interface_line_attribute6 = to_char(l_movement_transaction.order_line_id)

Line 2361: FROM mtl_material_transactions mmt_logical,

2357: AND ratl.interface_line_attribute6 = to_char(l_movement_transaction.order_line_id)
2358: AND ratl.interface_line_context = 'INTERCOMPANY'
2359: AND ratl.interface_line_attribute7 IN
2360: (SELECT mmt_logical.transaction_id
2361: FROM mtl_material_transactions mmt_logical,
2362: mtl_material_transactions mmt_physical
2363: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2364: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2365: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id

Line 2362: mtl_material_transactions mmt_physical

2358: AND ratl.interface_line_context = 'INTERCOMPANY'
2359: AND ratl.interface_line_attribute7 IN
2360: (SELECT mmt_logical.transaction_id
2361: FROM mtl_material_transactions mmt_logical,
2362: mtl_material_transactions mmt_physical
2363: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2364: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2365: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id
2366: AND mmt_physical.transaction_type_id = 33 -- to identify physical

Line 2452: , mtl_material_transactions mmt

2448: , RA_CUSTOMER_TRX_LINES_ALL rctla
2449: , ra_customer_trx_all rcta
2450: , rcv_transactions rcv
2451: , rcv_shipment_lines rsl
2452: , mtl_material_transactions mmt
2453: WHERE aia.invoice_id = aila.invoice_id
2454: AND aia.cancelled_date IS NULL
2455: AND aila.line_type_lookup_code = 'ITEM'
2456: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2492: , mtl_material_transactions mmt

2488: AP_INVOICES_ALL aia
2489: , AP_INVOICE_LINES_ALL aila
2490: , RA_CUSTOMER_TRX_LINES_ALL rctla
2491: , ra_customer_trx_all rcta
2492: , mtl_material_transactions mmt
2493: WHERE aia.invoice_id = aila.invoice_id
2494: AND aia.cancelled_date IS NULL
2495: AND aila.line_type_lookup_code = 'ITEM'
2496: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2550: FROM mtl_material_transactions mmt_logical,

2546: WHERE aida.invoice_id = aia.invoice_id
2547: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2548: AND aila.reference_2 in
2549: (SELECT mmt_logical.transaction_id
2550: FROM mtl_material_transactions mmt_logical,
2551: mtl_material_transactions mmt_physical
2552: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2553: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2554: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id

Line 2551: mtl_material_transactions mmt_physical

2547: AND NVL(aida.match_status_flag, 'N') NOT in ('N', 'S'))
2548: AND aila.reference_2 in
2549: (SELECT mmt_logical.transaction_id
2550: FROM mtl_material_transactions mmt_logical,
2551: mtl_material_transactions mmt_physical
2552: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2553: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2554: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id
2555: AND mmt_physical.transaction_type_id = 33 -- to identify physical

Line 2573: , mtl_material_transactions mmt

2569: AP_INVOICES_ALL aia
2570: , AP_INVOICE_LINES_ALL aila
2571: , RA_CUSTOMER_TRX_LINES_ALL rctla
2572: , ra_customer_trx_all rcta
2573: , mtl_material_transactions mmt
2574: WHERE aia.invoice_id = aila.invoice_id
2575: AND aia.cancelled_date IS NULL
2576: AND aila.line_type_lookup_code = 'ITEM'
2577: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)

Line 2622: , mtl_material_transactions mmt

2618: AP_INVOICES_ALL aia
2619: , RA_CUSTOMER_TRX_LINES_ALL rctla
2620: , rcv_transactions rcv
2621: , rcv_shipment_lines rsl
2622: , mtl_material_transactions mmt
2623: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2624: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2625: AND rctla.sales_order = to_char(l_movement_transaction.order_number)
2626: AND rctla.interface_line_attribute6 =

Line 2642: , mtl_material_transactions mmt

2638: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2639: FROM
2640: AP_INVOICES_ALL aia
2641: , RA_CUSTOMER_TRX_LINES_ALL rctla
2642: , mtl_material_transactions mmt
2643: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2644: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2645: AND rctla.sales_order = to_char(l_movement_transaction.order_number)
2646: AND rctla.interface_line_attribute6 =

Line 2659: , mtl_material_transactions mmt

2655: ,NVL(rctla.quantity_invoiced,0) InvoicedQuantity
2656: FROM
2657: AP_INVOICES_ALL aia
2658: , RA_CUSTOMER_TRX_LINES_ALL rctla
2659: , mtl_material_transactions mmt
2660: WHERE aia.invoice_id = x_movement_transaction.invoice_id
2661: AND aia.reference_1 = TO_CHAR(rctla.customer_trx_id)
2662: AND rctla.sales_order = to_char(l_movement_transaction.order_number)
2663: AND rctla.interface_line_attribute6 =

Line 2683: FROM mtl_material_transactions mmt_logical,

2679: AND rctla.interface_line_attribute6 =
2680: to_char(l_movement_transaction.order_line_id)
2681: AND rctla.interface_line_attribute7 IN
2682: (SELECT mmt_logical.transaction_id
2683: FROM mtl_material_transactions mmt_logical,
2684: mtl_material_transactions mmt_physical
2685: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2686: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2687: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id

Line 2684: mtl_material_transactions mmt_physical

2680: to_char(l_movement_transaction.order_line_id)
2681: AND rctla.interface_line_attribute7 IN
2682: (SELECT mmt_logical.transaction_id
2683: FROM mtl_material_transactions mmt_logical,
2684: mtl_material_transactions mmt_physical
2685: WHERE mmt_physical.picking_line_id = l_movement_transaction.picking_line_detail_id
2686: AND mmt_logical.parent_transaction_id = mmt_physical.parent_transaction_id
2687: AND mmt_logical.trx_source_line_id = mmt_physical.trx_source_line_id
2688: AND mmt_physical.transaction_type_id = 33 -- to identify physical

Line 4759: FROM MTL_MATERIAL_TRANSACTIONS MMT

4755: ELSIF x_movement_transaction.document_source_type = 'INV'
4756: THEN
4757: SELECT transaction_date
4758: INTO l_transaction_date
4759: FROM MTL_MATERIAL_TRANSACTIONS MMT
4760: WHERE MMT.transaction_id = x_movement_transaction.mtl_transaction_id;
4761: ELSE
4762: SELECT transaction_date
4763: INTO l_transaction_date