APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 1073: from mtl_system_items_vl sitems

1069: if (item_identifier_type is null or item_identifier_type = 'INT')
1070: or (p_print_description in ('I','D','F')) then
1071: select sitems.description description
1072: into v_description
1073: from mtl_system_items_vl sitems
1074: -- where sitems.customer_order_enabled_flag = 'Y'
1075: -- and sitems.bom_item_type in (1,4)
1076: where nvl(sitems.organization_id,0) = c_master_org
1077: and sitems.inventory_item_id = ITEM_DSPFORMULA.inventory_item_id;

Line 1099: mtl_system_items_vl sitems

1095: nvl(citems.customer_item_desc,sitems.description) description
1096: into v_item,v_description
1097: from mtl_customer_items citems,
1098: mtl_customer_item_xrefs cxref,
1099: mtl_system_items_vl sitems
1100: where citems.customer_item_id = cxref.customer_item_id
1101: and cxref.inventory_item_id = sitems.inventory_item_id
1102: and citems.customer_item_id = ordered_item_id
1103: and nvl(sitems.organization_id,0) = c_master_org

Line 1114: mtl_system_items_vl sitems

1110: nvl(items.description,sitems.description) description
1111: into v_item,v_description
1112: from mtl_cross_reference_types xtypes,
1113: mtl_cross_references items,
1114: mtl_system_items_vl sitems
1115: where xtypes.cross_reference_type = items.cross_reference_type
1116: and items.inventory_item_id = sitems.inventory_item_id
1117: and items.cross_reference = ordered_item
1118: and items.cross_reference_type = item_identifier_type

Line 1132: mtl_system_items_vl sitems

1128: nvl(items.description,sitems.description) description
1129: into v_item,v_description
1130: from mtl_cross_reference_types xtypes,
1131: mtl_cross_references items,
1132: mtl_system_items_vl sitems
1133: where xtypes.cross_reference_type =
1134: items.cross_reference_type
1135: and items.inventory_item_id =
1136: sitems.inventory_item_id