DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 2086: from mtl_system_items_vl sitems

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

Line 2107: mtl_system_items_vl sitems

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

Line 2120: mtl_system_items_vl sitems

2116: nvl(items.description,sitems.description) description
2117: into v_item,v_description
2118: from mtl_cross_reference_types xtypes,
2119: mtl_cross_references items,
2120: mtl_system_items_vl sitems
2121: where xtypes.cross_reference_type = items.cross_reference_type
2122: and items.inventory_item_id = sitems.inventory_item_id
2123: and items.cross_reference = ORDERED_ITEM
2124: and items.cross_reference_type = ITEM_IDENTIFIER_TYPE

Line 2136: mtl_system_items_vl sitems

2132: nvl(items.description,sitems.description) description
2133: into v_item, v_description
2134: from mtl_cross_reference_types xtypes,
2135: mtl_cross_references items,
2136: mtl_system_items_vl sitems
2137: where xtypes.cross_reference_type =
2138: items.cross_reference_type
2139: and items.inventory_item_id = sitems.inventory_item_id
2140: and items.cross_reference = ORDERED_ITEM