APPS.ONT_OEXOEACK_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 1310: from mtl_system_items_vl sitems

1306: if (item_identifier_type is null or item_identifier_type = 'INT')
1307: or (p_print_description in ('I','D','F')) then
1308: select sitems.description description
1309: into v_description
1310: from mtl_system_items_vl sitems
1311: where nvl(sitems.organization_id,0) = c_master_org
1312: and sitems.inventory_item_id = ITEM_DSPFORMULA.inventory_item_id;
1313:
1314:

Line 1327: mtl_system_items_vl sitems

1323: nvl(citems.customer_item_desc,sitems.description) description
1324: into v_item,v_description
1325: from mtl_customer_items citems,
1326: mtl_customer_item_xrefs cxref,
1327: mtl_system_items_vl sitems
1328: where citems.customer_item_id = cxref.customer_item_id
1329: and cxref.inventory_item_id = sitems.inventory_item_id
1330: and citems.customer_item_id = ordered_item_id
1331: and nvl(sitems.organization_id,0) = c_master_org

Line 1341: mtl_system_items_vl sitems

1337: nvl(items.description,sitems.description) description
1338: into v_item,v_description
1339: from mtl_cross_reference_types xtypes,
1340: mtl_cross_references items,
1341: mtl_system_items_vl sitems
1342: where xtypes.cross_reference_type = items.cross_reference_type
1343: and items.inventory_item_id = sitems.inventory_item_id
1344: and items.cross_reference = ordered_item
1345: and items.cross_reference_type = item_identifier_type

Line 1359: mtl_system_items_vl sitems

1355: nvl(items.description,sitems.description) description
1356: into v_item,v_description
1357: from mtl_cross_reference_types xtypes,
1358: mtl_cross_references items,
1359: mtl_system_items_vl sitems
1360: where xtypes.cross_reference_type = items.cross_reference_type
1361: and items.inventory_item_id = sitems.inventory_item_id
1362: and items.cross_reference = ordered_item
1363: and items.cross_reference_type = item_identifier_type