APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_ITEM_UOMS_VIEW

Line 2394: FROM mtl_item_uoms_view

2390:
2391: IF (p_rcvtxn_uom_code IS NULL) THEN
2392: SELECT uom_code
2393: INTO l_rcvtxn_uom_code
2394: FROM mtl_item_uoms_view
2395: WHERE organization_id = p_organization_id
2396: AND inventory_item_id = p_item_id
2397: AND unit_of_measure = p_rcvtxn_uom
2398: AND ROWNUM < 2;

Line 3104: FROM mtl_item_uoms_view

3100:
3101: IF (p_rcvtxn_uom_code IS NULL) THEN
3102: SELECT uom_code
3103: INTO l_rcvtxn_uom_code
3104: FROM mtl_item_uoms_view
3105: WHERE organization_id = p_organization_id
3106: AND inventory_item_id = p_item_id
3107: AND unit_of_measure = p_rcvtxn_uom
3108: AND ROWNUM < 2;

Line 3767: FROM mtl_item_uoms_view

3763:
3764: IF (p_rcvtxn_uom_code IS NULL) THEN
3765: SELECT uom_code
3766: INTO l_rcvtxn_uom_code
3767: FROM mtl_item_uoms_view
3768: WHERE organization_id = p_organization_id
3769: AND inventory_item_id = p_item_id
3770: AND unit_of_measure = p_rcvtxn_uom
3771: AND ROWNUM < 2;

Line 4922: FROM mtl_item_uoms_view

4918:
4919: --dbms_output.put_line('In create putaway move order');
4920: SELECT unit_of_measure
4921: INTO l_rcvtxn_uom
4922: FROM mtl_item_uoms_view
4923: WHERE organization_id = p_organization_id
4924: AND inventory_item_id = p_item_id
4925: AND uom_code = p_rcvtxn_uom_code
4926: AND ROWNUM < 2;

Line 5792: mtl_item_uoms_view WHERE organization_id=p_organization_id

5788: /*7429358*/
5789: BEGIN
5790:
5791: SELECT UOM_CODE INTO l_rtv_rec.uom_code FROM
5792: mtl_item_uoms_view WHERE organization_id=p_organization_id
5793: AND inventory_item_id = p_item_id
5794: AND unit_of_measure =
5795: ( SELECT unit_of_measure FROM RCV_TRANSACTIONS
5796: WHERE TRANSACTION_ID = l_rtv_rec.rcv_transaction_id);