APPS.INV_MGD_MVT_PO_MDTR dependencies on MTL_MOVEMENT_STATISTICS

Line 451: MTL_MOVEMENT_STATISTICS

447: CURSOR l_adj IS
448: SELECT
449: period_name
450: FROM
451: MTL_MOVEMENT_STATISTICS
452: WHERE movement_id = l_parent_id;
453:
454: --Fix bug 2412655, PO correction transaction
455: --Curor to get corrected quantity

Line 1637: mtl_movement_statistics

1633: x_movement_id
1634: , x_movement_status
1635: , x_source_type
1636: FROM
1637: mtl_movement_statistics
1638: WHERE usage_type = p_movement_transaction.usage_type
1639: AND stat_type = p_movement_transaction.stat_type
1640: AND zone_code = p_movement_transaction.zone_code
1641: AND entity_org_id = p_movement_transaction.entity_org_id

Line 1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;

1775: , x_return_status OUT NOCOPY VARCHAR2
1776: )
1777: IS
1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:

Line 1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;

1776: )
1777: IS
1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;