APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 995: from mtl_system_items_vl sitems

991: --v_item := :item_flex;
992:
993: select sitems.description description
994: into v_description
995: from mtl_system_items_vl sitems
996: where
997: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
998: and sitems.inventory_item_id = IID;
999:

Line 1019: mtl_system_items_vl sitems

1015: nvl(citems.customer_item_desc,sitems.description) description
1016: into v_item,v_description
1017: from mtl_customer_items citems,
1018: mtl_customer_item_xrefs cxref,
1019: mtl_system_items_vl sitems
1020: where citems.customer_item_id = cxref.customer_item_id
1021: and cxref.inventory_item_id = sitems.inventory_item_id
1022: and citems.customer_item_id = ordered_item_id
1023: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 1032: mtl_system_items_vl sitems

1028: nvl(items.description,sitems.description) description
1029: into v_item,v_description
1030: from mtl_cross_reference_types xtypes,
1031: mtl_cross_references items,
1032: mtl_system_items_vl sitems
1033: where xtypes.cross_reference_type = items.cross_reference_type
1034: and items.inventory_item_id = sitems.inventory_item_id
1035: and items.cross_reference = ORDERED_ITEM
1036: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T

Line 1047: mtl_system_items_vl sitems

1043: nvl(items.description,sitems.description) description
1044: into v_item,v_description
1045: from mtl_cross_reference_types xtypes,
1046: mtl_cross_references items,
1047: mtl_system_items_vl sitems
1048: where xtypes.cross_reference_type = items.cross_reference_type
1049: and items.inventory_item_id = sitems.inventory_item_id
1050: and items.cross_reference = ORDERED_ITEM
1051: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE_T