DBA Data[Home] [Help]

APPS.ONT_OEXOEORD_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 583: from mtl_system_items_vl sitems

579: or (p_print_description in ('I','D','F')) then
580: select sitems.concatenated_segments item,
581: sitems.description description
582: into v_item,v_description
583: from mtl_system_items_vl sitems
584: -- where sitems.customer_order_enabled_flag = 'Y'
585: -- and sitems.bom_item_type in (1,4)
586: where nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
587: and sitems.inventory_item_id = inventory_item_id1;

Line 596: mtl_system_items_vl sitems

592: nvl(citems.customer_item_desc,sitems.description) description
593: into v_item,v_description
594: from mtl_customer_items citems,
595: mtl_customer_item_xrefs cxref,
596: mtl_system_items_vl sitems
597: where citems.customer_item_id = cxref.customer_item_id
598: and cxref.inventory_item_id = sitems.inventory_item_id
599: and citems.customer_item_id = ordered_item_id
600: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)

Line 611: mtl_system_items_vl sitems

607: nvl(items.description,sitems.description) description
608: into v_item,v_description
609: from mtl_cross_reference_types xtypes,
610: mtl_cross_references items,
611: mtl_system_items_vl sitems
612: where xtypes.cross_reference_type = items.cross_reference_type
613: and items.inventory_item_id = sitems.inventory_item_id
614: and items.cross_reference = ordered_item
615: and items.cross_reference_type = item_identifier_type

Line 629: mtl_system_items_vl sitems

625: nvl(items.description,sitems.description) description into
626: v_item,v_description
627: from mtl_cross_reference_types xtypes,
628: mtl_cross_references items,
629: mtl_system_items_vl sitems
630: where xtypes.cross_reference_type =
631: items.cross_reference_type
632: and items.inventory_item_id =
633: sitems.inventory_item_id