APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_ITEM_UOMS_VIEW

Line 6: g_transfer_uom_code MTL_ITEM_UOMS_VIEW.UOM_CODE%TYPE;

2: /* $Header: INVSTDTB.pls 120.11.12020000.5 2012/08/10 10:08:08 rdudani ship $ */
3:
4: --Transaction UOM Code in RTI. Need this because the rcv_transactions
5: --record type does not store the uom_code
6: g_transfer_uom_code MTL_ITEM_UOMS_VIEW.UOM_CODE%TYPE;
7:
8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_STD_TRANSFER_APIS';
9:
10: /* Debugging utility*/

Line 932: FROM mtl_item_uoms_view

928: END IF;
929:
930: SELECT uom_code
931: INTO l_rcvtxn_uom_code
932: FROM mtl_item_uoms_view
933: WHERE organization_id = p_organization_id
934: AND inventory_item_id = p_item_id
935: AND unit_of_measure = l_rcvtxn_uom;
936:

Line 1283: FROM mtl_item_uoms_view

1279: AND organization_id = p_organization_id;
1280:
1281: SELECT unit_of_measure
1282: INTO l_transfer_uom
1283: FROM mtl_item_uoms_view
1284: WHERE organization_id = p_organization_id
1285: AND inventory_item_id = p_item_id
1286: AND uom_code = l_transfer_uom_code;
1287:

Line 1294: FROM mtl_item_uoms_view

1290: IF l_sec_transfer_uom_code IS NOT NULL THEN
1291:
1292: SELECT unit_of_measure
1293: INTO l_sec_transfer_uom
1294: FROM mtl_item_uoms_view
1295: WHERE organization_id = p_organization_id
1296: AND inventory_item_id = p_item_id
1297: AND uom_code = l_sec_transfer_uom_code;
1298:

Line 1707: FROM mtl_item_uoms_view

1703: AND organization_id = p_organization_id;
1704:
1705: SELECT unit_of_measure
1706: INTO l_transfer_uom
1707: FROM mtl_item_uoms_view
1708: WHERE inventory_item_id = p_item_id
1709: AND organization_id = p_organization_id
1710: AND uom_code = l_transfer_uom_code;
1711:

Line 1717: FROM mtl_item_uoms_view

1713: IF l_sec_transfer_uom_code IS NOT NULL THEN
1714:
1715: SELECT unit_of_measure
1716: INTO l_sec_transfer_uom
1717: FROM mtl_item_uoms_view
1718: WHERE inventory_item_id = p_item_id
1719: AND organization_id = p_organization_id
1720: AND uom_code = l_sec_transfer_uom_code;
1721:

Line 2124: FROM mtl_item_uoms_view

2120: AND organization_id = p_organization_id;
2121:
2122: SELECT unit_of_measure
2123: INTO l_transfer_uom
2124: FROM mtl_item_uoms_view
2125: WHERE inventory_item_id = p_item_id
2126: AND organization_id = p_organization_id
2127: AND uom_code = l_transfer_uom_code;
2128:

Line 2134: FROM mtl_item_uoms_view

2130: IF l_sec_transfer_uom_code IS NOT NULL THEN
2131:
2132: SELECT unit_of_measure
2133: INTO l_sec_transfer_uom
2134: FROM mtl_item_uoms_view
2135: WHERE inventory_item_id = p_item_id
2136: AND organization_id = p_organization_id
2137: AND uom_code = l_sec_transfer_uom_code;
2138: