APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 987: from mtl_system_items_vl sitems

983: --v_item := :item_flex;
984:
985: select sitems.description description
986: into v_description
987: from mtl_system_items_vl sitems
988: where
989: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
990: and sitems.inventory_item_id = IID;
991:

Line 1011: mtl_system_items_vl sitems

1007: nvl(citems.customer_item_desc,sitems.description) description
1008: into v_item,v_description
1009: from mtl_customer_items citems,
1010: mtl_customer_item_xrefs cxref,
1011: mtl_system_items_vl sitems
1012: where citems.customer_item_id = cxref.customer_item_id
1013: and cxref.inventory_item_id = sitems.inventory_item_id
1014: and citems.customer_item_id = ordered_item_id
1015: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 1024: mtl_system_items_vl sitems

1020: nvl(items.description,sitems.description) description
1021: into v_item,v_description
1022: from mtl_cross_reference_types xtypes,
1023: mtl_cross_references items,
1024: mtl_system_items_vl sitems
1025: where xtypes.cross_reference_type = items.cross_reference_type
1026: and items.inventory_item_id = sitems.inventory_item_id
1027: and items.cross_reference = ORDERED_ITEM
1028: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T

Line 1039: mtl_system_items_vl sitems

1035: nvl(items.description,sitems.description) description
1036: into v_item,v_description
1037: from mtl_cross_reference_types xtypes,
1038: mtl_cross_references items,
1039: mtl_system_items_vl sitems
1040: where xtypes.cross_reference_type = items.cross_reference_type
1041: and items.inventory_item_id = sitems.inventory_item_id
1042: and items.cross_reference = ORDERED_ITEM
1043: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T