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 2932: mtl_movement_statistics mms

2928: SELECT
2929: mms.movement_id
2930: , mms.movement_status
2931: FROM
2932: mtl_movement_statistics mms
2933: , rcv_transactions rt
2934: WHERE mms.rcv_transaction_id = rt.parent_transaction_id
2935: AND rt.transaction_id = x_mvt_rtv_transaction.rcv_transaction_id
2936: AND mms.entity_org_id = x_mvt_rtv_transaction.entity_org_id

Line 3093: mtl_movement_statistics

3089: , edi_transaction_date
3090: , edi_transaction_reference
3091: , esl_drop_shipment_code
3092: FROM
3093: mtl_movement_statistics
3094: WHERE movement_id = l_parent_mvt_id;
3095:
3096: BEGIN
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3458: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;

3454: l_insert_status VARCHAR2(10);
3455: l_movement_id NUMBER;
3456: -- l_trans_date DATE;
3457: l_par_mvt_id NUMBER;
3458: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;
3459: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;
3460: l_update_status VARCHAR2(1);
3461: l_dropship_source_id NUMBER;
3462: l_le_terr_code VARCHAR2(2);

Line 3459: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;

3455: l_movement_id NUMBER;
3456: -- l_trans_date DATE;
3457: l_par_mvt_id NUMBER;
3458: l_par_movement_status mtl_movement_statistics.movement_status%TYPE;
3459: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;
3460: l_update_status VARCHAR2(1);
3461: l_dropship_source_id NUMBER;
3462: l_le_terr_code VARCHAR2(2);
3463: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;

Line 4363: mtl_movement_statistics mms

4359: SELECT
4360: mms.movement_id
4361: , mms.movement_status
4362: FROM
4363: mtl_movement_statistics mms
4364: , oe_order_lines_all oola
4365: WHERE mms.order_header_id = oola.reference_header_id
4366: AND mms.order_line_id = oola.reference_line_id
4367: AND oola.line_id = x_mvt_rma_transaction.order_line_id

Line 4524: mtl_movement_statistics

4520: , edi_transaction_date
4521: , edi_transaction_reference
4522: , esl_drop_shipment_code
4523: FROM
4524: mtl_movement_statistics
4525: WHERE movement_id = l_parent_mvt_id;
4526:
4527: BEGIN
4528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

4897: l_api_name CONSTANT VARCHAR2(30) := 'Process_RMA_Transaction';
4898: l_error VARCHAR2(600);
4899: l_sold_from_org_code VARCHAR2(2); -- 7165989
4900: l_mvt_stat_status RCV_TRANSACTIONS.mvt_stat_status%TYPE; -- 7165989
4901: l_dispatch mtl_movement_statistics.dispatch_territory_code%TYPE;-- 7165989
4902: l_destination mtl_movement_statistics.destination_territory_code%TYPE;-- 7165989
4903: l_insert VARCHAR2(1);-- 7165989
4904: l_ship_from_loc VARCHAR2(10);-- 7165989
4905: l_ship_to_loc VARCHAR2(10);-- 7165989

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

4898: l_error VARCHAR2(600);
4899: l_sold_from_org_code VARCHAR2(2); -- 7165989
4900: l_mvt_stat_status RCV_TRANSACTIONS.mvt_stat_status%TYPE; -- 7165989
4901: l_dispatch mtl_movement_statistics.dispatch_territory_code%TYPE;-- 7165989
4902: l_destination mtl_movement_statistics.destination_territory_code%TYPE;-- 7165989
4903: l_insert VARCHAR2(1);-- 7165989
4904: l_ship_from_loc VARCHAR2(10);-- 7165989
4905: l_ship_to_loc VARCHAR2(10);-- 7165989
4906: