APPS.AMS_RUNTIME_PROD_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1779: from mtl_system_items_vl MSIV

1775: l_api_version CONSTANT NUMBER := 1.0;
1776:
1777: cursor l_uom_csr(l_itmid NUMBER) IS
1778: select MSIV.primary_uom_code
1779: from mtl_system_items_vl MSIV
1780: where MSIV.inventory_item_id = l_itmid;
1781:
1782: l_item_stmt VARCHAR2(4000) :=
1783: 'SELECT MSIV.INVENTORY_ITEM_ID, MSIV.CONCATENATED_SEGMENTS,' ||

Line 1787: ' FROM MTL_SYSTEM_ITEMS_VL MSIV ' ||

1783: 'SELECT MSIV.INVENTORY_ITEM_ID, MSIV.CONCATENATED_SEGMENTS,' ||
1784: ' MSIV.ORDERABLE_ON_WEB_FLAG, MSIV.PRIMARY_UNIT_OF_MEASURE,' ||
1785: ' MSIV.PRIMARY_UOM_CODE, MSIV.DESCRIPTION, MSIV.LONG_DESCRIPTION,' ||
1786: ' MSIV.MINIMUM_ORDER_QUANTITY, MSIV.MAXIMUM_ORDER_QUANTITY' ||
1787: ' FROM MTL_SYSTEM_ITEMS_VL MSIV ' ||
1788: ' WHERE MSIV.ORGANIZATION_ID = :org_id' ||
1789: ' AND MSIV.WEB_STATUS = ''PUBLISHED'''||
1790: ' AND NVL(MSIV.START_DATE_ACTIVE, SYSDATE) <= SYSDATE ' ||
1791: ' AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE ' ||

Line 1796: ' FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES MIC' ||

1792: ' AND MSIV.INVENTORY_ITEM_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_itmid_tbl AS JTF_NUMBER_TABLE)) t)';
1793:
1794: l_category_stmt VARCHAR2(4000) :=
1795: 'SELECT MSIV.INVENTORY_ITEM_ID, MIC.CATEGORY_ID' ||
1796: ' FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES MIC' ||
1797: ' WHERE MSIV.ORGANIZATION_ID = :org_id' ||
1798: ' AND NVL(MSIV.START_DATE_ACTIVE, SYSDATE) <= SYSDATE' ||
1799: ' AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE' ||
1800: ' AND MSIV.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID' ||