APPS.INV_CONVERT dependencies on MTL_SYSTEM_ITEMS

Line 794: from mtl_system_items msi,

790: l_uom_class varchar2(10) := null;
791:
792: Cursor c_msi is
793: select PRIMARY_UOM_CODE, ALLOWED_UNITS_LOOKUP_CODE
794: from mtl_system_items msi,
795: MTL_UNITS_OF_MEASURE MTLUOM2
796: where msi.ORGANIZATION_ID = p_organization_id AND
797: msi.INVENTORY_ITEM_ID = p_item_id AND
798: MTLUOM2.uom_code = msi.PRIMARY_UOM_CODE AND

Line 1323: FROM mtl_system_items msi ,

1319: ELSE
1320:
1321: SELECT 'Y'
1322: INTO l_uom_in_same_class
1323: FROM mtl_system_items msi ,
1324: mtl_item_uoms_view mv1,
1325: mtl_item_uoms_view mv2
1326: WHERE msi.organization_id = p_organization_id
1327: AND msi.inventory_item_id = p_item_id

Line 1732: FROM mtl_system_items_vl

1728: IF p_item_id <> 0 THEN
1729: BEGIN
1730: SELECT DISTINCT inventory_item_id
1731: INTO l_temp_item_id
1732: FROM mtl_system_items_vl
1733: WHERE inventory_item_id = p_item_id
1734: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1735: WHERE I.enabled_flag = 'Y'
1736: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )

Line 1734: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I

1730: SELECT DISTINCT inventory_item_id
1731: INTO l_temp_item_id
1732: FROM mtl_system_items_vl
1733: WHERE inventory_item_id = p_item_id
1734: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1735: WHERE I.enabled_flag = 'Y'
1736: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1737: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1738: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A

Line 1762: from mtl_units_of_measure z , mtl_system_items_vl m

1758: WHERE (a.uom_class in (select to_uom_class
1759: from mtl_uom_class_conversions b
1760: where b.inventory_item_id = p_item_id)
1761: or a.uom_class =(select DISTINCT z.uom_class
1762: from mtl_units_of_measure z , mtl_system_items_vl m
1763: where m.inventory_item_id = p_item_id
1764: AND z.uom_code = m.primary_uom_code
1765: ))
1766: and a.base_uom_flag <> 'Y'

Line 1843: FROM mtl_system_items_vl

1839: END IF ;
1840:
1841: BEGIN
1842: SELECT DISTINCT inventory_item_id , primary_uom_code INTO l_temp_item_id , l_primary_uom_code
1843: FROM mtl_system_items_vl
1844: WHERE inventory_item_id = p_item_id
1845: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1846: WHERE I.enabled_flag = 'Y'
1847: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )

Line 1845: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I

1841: BEGIN
1842: SELECT DISTINCT inventory_item_id , primary_uom_code INTO l_temp_item_id , l_primary_uom_code
1843: FROM mtl_system_items_vl
1844: WHERE inventory_item_id = p_item_id
1845: AND inventory_item_id IN (SELECT DISTINCT I.inventory_item_id FROM mtl_system_items_vl I
1846: WHERE I.enabled_flag = 'Y'
1847: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1848: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1849: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A