APPS.INV_MGD_MVT_PO_MDTR dependencies on MTL_MOVEMENT_STATISTICS

Line 445: MTL_MOVEMENT_STATISTICS

441: CURSOR l_adj IS
442: SELECT
443: period_name
444: FROM
445: MTL_MOVEMENT_STATISTICS
446: WHERE movement_id = l_parent_id;
447:
448: --Fix bug 2412655, PO correction transaction
449: --Curor to get corrected quantity

Line 1482: mtl_movement_statistics

1478: x_movement_id
1479: , x_movement_status
1480: , x_source_type
1481: FROM
1482: mtl_movement_statistics
1483: WHERE usage_type = p_movement_transaction.usage_type
1484: AND stat_type = p_movement_transaction.stat_type
1485: AND zone_code = p_movement_transaction.zone_code
1486: AND entity_org_id = p_movement_transaction.entity_org_id

Line 1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;

1616: , x_return_status OUT NOCOPY VARCHAR2
1617: )
1618: IS
1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:

Line 1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;

1617: )
1618: IS
1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;