DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on MTL_MOVEMENT_STATISTICS

Line 1036: FROM mtl_movement_statistics

1032: AND rt.mvt_stat_status = 'PROCESSED'
1033: AND rt.transaction_type = 'DELIVER'
1034: AND ratl.interface_line_context <> 'INTERCOMPANY'
1035: AND oola.line_id NOT IN (SELECT order_line_id
1036: FROM mtl_movement_statistics
1037: WHERE entity_org_id = p_movement_transaction.entity_org_id
1038: AND zone_code = p_movement_transaction.zone_code
1039: AND usage_type = p_movement_transaction.usage_type
1040: AND stat_type = p_movement_transaction.stat_type

Line 1077: FROM mtl_movement_statistics

1073: WHERE po_header_id = p_movement_transaction.po_header_id
1074: AND transaction_type = 'RETURN TO VENDOR'
1075: AND mvt_stat_status = 'PROCESSED'
1076: AND transaction_id NOT IN (SELECT rcv_transaction_id
1077: FROM mtl_movement_statistics
1078: WHERE document_source_type = 'RTV'
1079: AND po_header_id = rt.po_header_id
1080: AND entity_org_id = p_movement_transaction.entity_org_id
1081: AND zone_code = p_movement_transaction.zone_code