APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 2090: from mtl_system_items_vl sitems

2086: or (P_PRINT_DESCRIPTION in ('I','D','F')) then
2087: select sitems.concatenated_segments item,
2088: sitems.description description
2089: into v_item,v_description
2090: from mtl_system_items_vl sitems
2091: where nvl(sitems.organization_id,0) = C_MASTER_ORG
2092: and sitems.inventory_item_id = INVENTORY_ITEM_ID_T;
2093: /* srw.reference (:p_item_flex_code);
2094: srw.reference (:Item_dsp);

Line 2111: mtl_system_items_vl sitems

2107: nvl(citems.customer_item_desc,sitems.description) description
2108: into v_item,v_description
2109: from mtl_customer_items citems,
2110: mtl_customer_item_xrefs cxref,
2111: mtl_system_items_vl sitems
2112: where citems.customer_item_id = cxref.customer_item_id
2113: and cxref.inventory_item_id = sitems.inventory_item_id
2114: and citems.customer_item_id = ORDERED_ITEM_ID_T
2115: and nvl(sitems.organization_id,0) = C_MASTER_ORG

Line 2124: mtl_system_items_vl sitems

2120: nvl(items.description,sitems.description) description
2121: into v_item,v_description
2122: from mtl_cross_reference_types xtypes,
2123: mtl_cross_references items,
2124: mtl_system_items_vl sitems
2125: where xtypes.cross_reference_type = items.cross_reference_type
2126: and items.inventory_item_id = sitems.inventory_item_id
2127: and items.cross_reference = ORDERED_ITEM
2128: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE

Line 2140: mtl_system_items_vl sitems

2136: nvl(items.description,sitems.description) description
2137: into v_item, v_description
2138: from mtl_cross_reference_types xtypes,
2139: mtl_cross_references items,
2140: mtl_system_items_vl sitems
2141: where xtypes.cross_reference_type =
2142: items.cross_reference_type
2143: and items.inventory_item_id = sitems.inventory_item_id
2144: and items.cross_reference = ORDERED_ITEM