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_STATS_PROC dependencies on MTL_MOVEMENT_STATISTICS

Line 2624: mtl_movement_statistics mms

2620: SELECT
2621: mms.movement_id
2622: , mms.movement_status
2623: FROM
2624: mtl_movement_statistics mms
2625: , rcv_transactions rt
2626: WHERE mms.rcv_transaction_id = rt.parent_transaction_id
2627: AND rt.transaction_id = x_mvt_rtv_transaction.rcv_transaction_id
2628: AND mms.entity_org_id = x_mvt_rtv_transaction.entity_org_id

Line 2785: mtl_movement_statistics

2781: , edi_transaction_date
2782: , edi_transaction_reference
2783: , esl_drop_shipment_code
2784: FROM
2785: mtl_movement_statistics
2786: WHERE movement_id = l_parent_mvt_id;
2787:
2788: BEGIN
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3150: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;

3146: l_insert_status VARCHAR2(10);
3147: l_movement_id NUMBER;
3148: -- l_trans_date DATE;
3149: l_par_mvt_id NUMBER;
3150: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;
3151: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;
3152: l_update_status VARCHAR2(1);
3153: l_dropship_source_id NUMBER;
3154: l_le_terr_code VARCHAR2(2);

Line 3151: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;

3147: l_movement_id NUMBER;
3148: -- l_trans_date DATE;
3149: l_par_mvt_id NUMBER;
3150: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;
3151: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;
3152: l_update_status VARCHAR2(1);
3153: l_dropship_source_id NUMBER;
3154: l_le_terr_code VARCHAR2(2);
3155: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;

Line 4020: mtl_movement_statistics mms

4016: SELECT
4017: mms.movement_id
4018: , mms.movement_status
4019: FROM
4020: mtl_movement_statistics mms
4021: , oe_order_lines_all oola
4022: WHERE mms.order_header_id = oola.reference_header_id
4023: AND mms.order_line_id = oola.reference_line_id
4024: AND oola.line_id = x_mvt_rma_transaction.order_line_id

Line 4181: mtl_movement_statistics

4177: , edi_transaction_date
4178: , edi_transaction_reference
4179: , esl_drop_shipment_code
4180: FROM
4181: mtl_movement_statistics
4182: WHERE movement_id = l_parent_mvt_id;
4183:
4184: BEGIN
4185: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 4558: l_dispatch mtl_movement_statistics.dispatch_territory_code%TYPE;-- 7165989

4554: l_api_name CONSTANT VARCHAR2(30) := 'Process_RMA_Transaction';
4555: l_error VARCHAR2(600);
4556: l_sold_from_org_code VARCHAR2(2); -- 7165989
4557: l_mvt_stat_status RCV_TRANSACTIONS.mvt_stat_status%TYPE; -- 7165989
4558: l_dispatch mtl_movement_statistics.dispatch_territory_code%TYPE;-- 7165989
4559: l_destination mtl_movement_statistics.destination_territory_code%TYPE;-- 7165989
4560: l_insert VARCHAR2(1);-- 7165989
4561: l_ship_from_loc VARCHAR2(10);-- 7165989
4562: l_ship_to_loc VARCHAR2(10);-- 7165989

Line 4559: l_destination mtl_movement_statistics.destination_territory_code%TYPE;-- 7165989

4555: l_error VARCHAR2(600);
4556: l_sold_from_org_code VARCHAR2(2); -- 7165989
4557: l_mvt_stat_status RCV_TRANSACTIONS.mvt_stat_status%TYPE; -- 7165989
4558: l_dispatch mtl_movement_statistics.dispatch_territory_code%TYPE;-- 7165989
4559: l_destination mtl_movement_statistics.destination_territory_code%TYPE;-- 7165989
4560: l_insert VARCHAR2(1);-- 7165989
4561: l_ship_from_loc VARCHAR2(10);-- 7165989
4562: l_ship_to_loc VARCHAR2(10);-- 7165989
4563: