DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on MTL_MOVEMENT_STATISTICS

Line 1069: FROM mtl_movement_statistics

1065: AND rt.mvt_stat_status = 'PROCESSED'
1066: AND rt.transaction_type = 'DELIVER'
1067: AND ratl.interface_line_context <> 'INTERCOMPANY'
1068: AND oola.line_id NOT IN (SELECT order_line_id
1069: FROM mtl_movement_statistics
1070: WHERE entity_org_id = p_movement_transaction.entity_org_id
1071: AND zone_code = p_movement_transaction.zone_code
1072: AND usage_type = p_movement_transaction.usage_type
1073: AND stat_type = p_movement_transaction.stat_type

Line 1110: FROM mtl_movement_statistics

1106: WHERE po_header_id = p_movement_transaction.po_header_id
1107: AND transaction_type = 'RETURN TO VENDOR'
1108: AND mvt_stat_status = 'PROCESSED'
1109: AND transaction_id NOT IN (SELECT rcv_transaction_id
1110: FROM mtl_movement_statistics
1111: WHERE document_source_type = 'RTV'
1112: AND po_header_id = rt.po_header_id
1113: AND entity_org_id = p_movement_transaction.entity_org_id
1114: AND zone_code = p_movement_transaction.zone_code