APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_ITEM_UOMS_VIEW

Line 2360: FROM mtl_item_uoms_view

2356:
2357: IF (p_rcvtxn_uom_code IS NULL) THEN
2358: SELECT uom_code
2359: INTO l_rcvtxn_uom_code
2360: FROM mtl_item_uoms_view
2361: WHERE organization_id = p_organization_id
2362: AND inventory_item_id = p_item_id
2363: AND unit_of_measure = p_rcvtxn_uom
2364: AND ROWNUM < 2;

Line 3043: FROM mtl_item_uoms_view

3039:
3040: IF (p_rcvtxn_uom_code IS NULL) THEN
3041: SELECT uom_code
3042: INTO l_rcvtxn_uom_code
3043: FROM mtl_item_uoms_view
3044: WHERE organization_id = p_organization_id
3045: AND inventory_item_id = p_item_id
3046: AND unit_of_measure = p_rcvtxn_uom
3047: AND ROWNUM < 2;

Line 3671: FROM mtl_item_uoms_view

3667:
3668: IF (p_rcvtxn_uom_code IS NULL) THEN
3669: SELECT uom_code
3670: INTO l_rcvtxn_uom_code
3671: FROM mtl_item_uoms_view
3672: WHERE organization_id = p_organization_id
3673: AND inventory_item_id = p_item_id
3674: AND unit_of_measure = p_rcvtxn_uom
3675: AND ROWNUM < 2;

Line 4804: FROM mtl_item_uoms_view

4800:
4801: --dbms_output.put_line('In create putaway move order');
4802: SELECT unit_of_measure
4803: INTO l_rcvtxn_uom
4804: FROM mtl_item_uoms_view
4805: WHERE organization_id = p_organization_id
4806: AND inventory_item_id = p_item_id
4807: AND uom_code = p_rcvtxn_uom_code
4808: AND ROWNUM < 2;

Line 5657: mtl_item_uoms_view WHERE organization_id=p_organization_id

5653: /*7429358*/
5654: BEGIN
5655:
5656: SELECT UOM_CODE INTO l_rtv_rec.uom_code FROM
5657: mtl_item_uoms_view WHERE organization_id=p_organization_id
5658: AND inventory_item_id = p_item_id
5659: AND unit_of_measure =
5660: ( SELECT unit_of_measure FROM RCV_TRANSACTIONS
5661: WHERE TRANSACTION_ID = l_rtv_rec.rcv_transaction_id);