APPS.OE_VALIDATE_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 1664: , mtl_system_items_vl sitems

1660: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1661: DECODE(items.organization_id, item_val_org, 1, 2))
1662: FROM mtl_cross_reference_types types
1663: , mtl_cross_references items
1664: , mtl_system_items_vl sitems
1665: WHERE types.cross_reference_type = items.cross_reference_type
1666: AND items.inventory_item_id = sitems.inventory_item_id
1667: AND sitems.organization_id = item_val_org
1668: AND sitems.inventory_item_id = p_inventory_item_id

Line 1681: , mtl_system_items_vl sitems

1677: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1678: DECODE(items.organization_id, item_val_org, 1, 2))
1679: FROM mtl_cross_reference_types types
1680: , mtl_cross_references items
1681: , mtl_system_items_vl sitems
1682: WHERE types.cross_reference_type = items.cross_reference_type
1683: AND items.inventory_item_id = sitems.inventory_item_id
1684: AND sitems.organization_id = item_val_org
1685: AND sitems.inventory_item_id = p_inventory_item_id

Line 1830: ,mtl_system_items_vl sitems

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

Line 1851: ,mtl_system_items_vl sitems

1847: SELECT 'valid'
1848: INTO l_dummy
1849: FROM mtl_customer_items citems
1850: ,mtl_customer_item_xrefs cxref
1851: ,mtl_system_items_vl sitems
1852: ,mtl_parameters mp -- 4402603
1853: WHERE citems.customer_item_id = cxref.customer_item_id
1854: AND cxref.inventory_item_id = sitems.inventory_item_id
1855: AND sitems.inventory_item_id = p_inventory_item_id