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

Line 219: SELECT MTL_MOVEMENT_STATISTICS_S.NEXTVAL

215: END IF;
216:
217: IF (l_return_status1 = 'S' AND l_return_status2 = 'S')
218: THEN
219: SELECT MTL_MOVEMENT_STATISTICS_S.NEXTVAL
220: INTO l_parent_movement_id
221: FROM SYS.DUAL;
222:
223: INSERT INTO

Line 224: MTL_MOVEMENT_STATISTICS(

220: INTO l_parent_movement_id
221: FROM SYS.DUAL;
222:
223: INSERT INTO
224: MTL_MOVEMENT_STATISTICS(
225: movement_id
226: , organization_id
227: , entity_org_id
228: , movement_type

Line 836: MTL_MOVEMENT_STATISTICS mtl_stats

832: , mtl_stats.edi_transaction_date
833: , mtl_stats.edi_transaction_reference
834: , mtl_stats.esl_drop_shipment_code
835: FROM
836: MTL_MOVEMENT_STATISTICS mtl_stats
837: WHERE entity_org_id = p_legal_entity_id
838: AND period_name = p_period_name
839: AND document_source_type = nvl(p_document_source_type, document_source_type)
840: AND zone_code = p_economic_zone_code

Line 984: UPDATE MTL_MOVEMENT_STATISTICS

980: END IF;
981: END IF;
982: /*bug #7499719 End*/
983:
984: UPDATE MTL_MOVEMENT_STATISTICS
985: SET movement_id = P_MOVEMENT_STATISTICS.movement_id
986: , organization_id = P_MOVEMENT_STATISTICS.organization_id
987: , entity_org_id = P_MOVEMENT_STATISTICS.entity_org_id
988: , movement_type = P_MOVEMENT_STATISTICS.movement_type

Line 1972: DELETE FROM MTL_MOVEMENT_STATISTICS

1968: BEGIN
1969:
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971:
1972: DELETE FROM MTL_MOVEMENT_STATISTICS
1973: WHERE movement_id = p_movement_transaction.movement_id
1974: AND movement_status in ('O','V')
1975: AND edi_sent_flag = 'N';
1976:

Line 2136: UPDATE mtl_movement_statistics

2132: END IF;
2133:
2134: ----value match, correct value in the mvt_statistics table
2135: ELSE
2136: UPDATE mtl_movement_statistics
2137: SET customer_vat_number=l_form_vat_value
2138: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2139:
2140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2658: MTL_MOVEMENT_STATISTICS mtl_stats

2654: , mtl_stats.edi_transaction_date
2655: , mtl_stats.edi_transaction_reference
2656: , mtl_stats.esl_drop_shipment_code
2657: FROM
2658: MTL_MOVEMENT_STATISTICS mtl_stats
2659: WHERE entity_org_id = p_movement_transaction.entity_org_id
2660: AND document_source_type = DECODE(p_transaction_type,null,
2661: document_source_type,'ALL',document_source_type,p_transaction_type )
2662: AND transaction_date BETWEEN trunc(p_start_date -1) and trunc(p_end_date +1)

Line 2869: MTL_MOVEMENT_STATISTICS mtl_stats

2865: , mtl_stats.edi_transaction_date
2866: , mtl_stats.edi_transaction_reference
2867: , mtl_stats.esl_drop_shipment_code
2868: FROM
2869: MTL_MOVEMENT_STATISTICS mtl_stats
2870: WHERE entity_org_id = p_legal_entity_id
2871: AND document_source_type IN ('PO', 'RTV')
2872: AND movement_status IN ('O','V','P')
2873: AND transaction_date BETWEEN TRUNC(p_start_date -1)

Line 3081: MTL_MOVEMENT_STATISTICS mtl_stats

3077: , mtl_stats.edi_transaction_date
3078: , mtl_stats.edi_transaction_reference
3079: , mtl_stats.esl_drop_shipment_code
3080: FROM
3081: MTL_MOVEMENT_STATISTICS mtl_stats
3082: WHERE entity_org_id = p_movement_transaction.entity_org_id
3083: AND document_source_type = DECODE(p_document_source_type,null,
3084: document_source_type,'ALL',document_source_type,p_document_source_type )
3085: AND movement_status = 'P'