APPS.OE_VALIDATE_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 1640: , mtl_system_items_vl sitems

1636: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1637: DECODE(items.organization_id, item_val_org, 1, 2))
1638: FROM mtl_cross_reference_types types
1639: , mtl_cross_references items
1640: , mtl_system_items_vl sitems
1641: WHERE types.cross_reference_type = items.cross_reference_type
1642: AND items.inventory_item_id = sitems.inventory_item_id
1643: AND sitems.organization_id = item_val_org
1644: AND sitems.inventory_item_id = p_inventory_item_id

Line 1657: , mtl_system_items_vl sitems

1653: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1654: DECODE(items.organization_id, item_val_org, 1, 2))
1655: FROM mtl_cross_reference_types types
1656: , mtl_cross_references items
1657: , mtl_system_items_vl sitems
1658: WHERE types.cross_reference_type = items.cross_reference_type
1659: AND items.inventory_item_id = sitems.inventory_item_id
1660: AND sitems.organization_id = item_val_org
1661: AND sitems.inventory_item_id = p_inventory_item_id

Line 1806: ,mtl_system_items_vl sitems

1802: SELECT 'valid'
1803: INTO l_dummy
1804: FROM mtl_customer_items citems
1805: ,mtl_customer_item_xrefs cxref
1806: ,mtl_system_items_vl sitems
1807: ,mtl_parameters mp -- 4402603
1808: WHERE citems.customer_item_id = cxref.customer_item_id
1809: AND cxref.inventory_item_id = sitems.inventory_item_id
1810: AND sitems.inventory_item_id = p_inventory_item_id

Line 1827: ,mtl_system_items_vl sitems

1823: SELECT 'valid'
1824: INTO l_dummy
1825: FROM mtl_customer_items citems
1826: ,mtl_customer_item_xrefs cxref
1827: ,mtl_system_items_vl sitems
1828: ,mtl_parameters mp -- 4402603
1829: WHERE citems.customer_item_id = cxref.customer_item_id
1830: AND cxref.inventory_item_id = sitems.inventory_item_id
1831: AND sitems.inventory_item_id = p_inventory_item_id