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 199: SELECT MTL_MOVEMENT_STATISTICS_S.NEXTVAL

195: END IF;
196:
197: IF (l_return_status1 = 'S' AND l_return_status2 = 'S')
198: THEN
199: SELECT MTL_MOVEMENT_STATISTICS_S.NEXTVAL
200: INTO l_parent_movement_id
201: FROM SYS.DUAL;
202:
203: INSERT INTO

Line 204: MTL_MOVEMENT_STATISTICS(

200: INTO l_parent_movement_id
201: FROM SYS.DUAL;
202:
203: INSERT INTO
204: MTL_MOVEMENT_STATISTICS(
205: movement_id
206: , organization_id
207: , entity_org_id
208: , movement_type

Line 816: MTL_MOVEMENT_STATISTICS mtl_stats

812: , mtl_stats.edi_transaction_date
813: , mtl_stats.edi_transaction_reference
814: , mtl_stats.esl_drop_shipment_code
815: FROM
816: MTL_MOVEMENT_STATISTICS mtl_stats
817: WHERE entity_org_id = p_legal_entity_id
818: AND period_name = p_period_name
819: AND document_source_type = nvl(p_document_source_type, document_source_type)
820: AND zone_code = p_economic_zone_code

Line 944: UPDATE MTL_MOVEMENT_STATISTICS

940: END IF;
941: END IF;
942: /*bug #7499719 End*/
943:
944: UPDATE MTL_MOVEMENT_STATISTICS
945: SET movement_id = P_MOVEMENT_STATISTICS.movement_id
946: , organization_id = P_MOVEMENT_STATISTICS.organization_id
947: , entity_org_id = P_MOVEMENT_STATISTICS.entity_org_id
948: , movement_type = P_MOVEMENT_STATISTICS.movement_type

Line 1932: DELETE FROM MTL_MOVEMENT_STATISTICS

1928: BEGIN
1929:
1930: x_return_status := FND_API.G_RET_STS_SUCCESS;
1931:
1932: DELETE FROM MTL_MOVEMENT_STATISTICS
1933: WHERE movement_id = p_movement_transaction.movement_id
1934: AND movement_status in ('O','V')
1935: AND edi_sent_flag = 'N';
1936:

Line 2096: UPDATE mtl_movement_statistics

2092: END IF;
2093:
2094: ----value match, correct value in the mvt_statistics table
2095: ELSE
2096: UPDATE mtl_movement_statistics
2097: SET customer_vat_number=l_form_vat_value
2098: WHERE movement_id=p_mvt_transaction_rec.movement_id;
2099:
2100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2618: MTL_MOVEMENT_STATISTICS mtl_stats

2614: , mtl_stats.edi_transaction_date
2615: , mtl_stats.edi_transaction_reference
2616: , mtl_stats.esl_drop_shipment_code
2617: FROM
2618: MTL_MOVEMENT_STATISTICS mtl_stats
2619: WHERE entity_org_id = p_movement_transaction.entity_org_id
2620: AND document_source_type = DECODE(p_transaction_type,null,
2621: document_source_type,'ALL',document_source_type,p_transaction_type )
2622: AND transaction_date BETWEEN trunc(p_start_date -1) and trunc(p_end_date +1)

Line 2829: MTL_MOVEMENT_STATISTICS mtl_stats

2825: , mtl_stats.edi_transaction_date
2826: , mtl_stats.edi_transaction_reference
2827: , mtl_stats.esl_drop_shipment_code
2828: FROM
2829: MTL_MOVEMENT_STATISTICS mtl_stats
2830: WHERE entity_org_id = p_legal_entity_id
2831: AND document_source_type IN ('PO', 'RTV')
2832: AND movement_status IN ('O','V','P')
2833: AND transaction_date BETWEEN TRUNC(p_start_date -1)

Line 3041: MTL_MOVEMENT_STATISTICS mtl_stats

3037: , mtl_stats.edi_transaction_date
3038: , mtl_stats.edi_transaction_reference
3039: , mtl_stats.esl_drop_shipment_code
3040: FROM
3041: MTL_MOVEMENT_STATISTICS mtl_stats
3042: WHERE entity_org_id = p_movement_transaction.entity_org_id
3043: AND document_source_type = DECODE(p_document_source_type,null,
3044: document_source_type,'ALL',document_source_type,p_document_source_type )
3045: AND movement_status = 'P'