APPS.ONT_OEXOHOHS_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

    select sitems.description description
    into   v_description
    from   mtl_system_items_vl sitems
    Where    nvl(sitems.organization_id,0) = c_master_org_L
    and    sitems.inventory_item_id = inventory_item_id_L;

Line: 34

    select citems.customer_item_number item,
    	   nvl(citems.customer_item_desc,sitems.description) description
    into   v_item,v_description
    from   mtl_customer_items citems,
           mtl_customer_item_xrefs cxref,
           mtl_system_items_vl sitems
    where  citems.customer_item_id = cxref.customer_item_id
    and    cxref.inventory_item_id = sitems.inventory_item_id
    and    citems.customer_item_id = ordered_item_id_L
    and    nvl(sitems.organization_id,0) = c_master_org_L
    and    sitems.inventory_item_id = inventory_item_id_L;

Line: 49

    select items.cross_reference item,
    	   nvl(items.description,sitems.description) description
    into   v_item,v_description
    from   mtl_cross_reference_types xtypes,
           mtl_cross_references items,
           mtl_system_items_vl sitems
    where  xtypes.cross_reference_type = items.cross_reference_type
    and    items.inventory_item_id = sitems.inventory_item_id
    and    items.cross_reference = ordered_item_L
    and    items.cross_reference_type = item_identifier_type_L
    and    nvl(sitems.organization_id,0) = c_master_org_L
    and    sitems.inventory_item_id = inventory_item_id_L
-- Bug 3433353 Begin
    and items.org_independent_flag = 'N'
    and items.organization_id = c_master_org_L;

Line: 67

    select items.cross_reference item,
    nvl(items.description,sitems.description) description
    into v_item,v_description
    from mtl_cross_reference_types xtypes,
    mtl_cross_references items,
    mtl_system_items_vl sitems
    where xtypes.cross_reference_type =
    items.cross_reference_type
    and items.inventory_item_id =
     sitems.inventory_item_id
    and items.cross_reference = ordered_item_L
    and items.cross_reference_type = item_identifier_type_L
    and nvl(sitems.organization_id,0) = c_master_org_L
    and sitems.inventory_item_id = inventory_item_id_L
    and items.org_independent_flag = 'Y';

Line: 103

      SELECT
        NAME
      INTO SOB_NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 159

      SELECT
        MEANING
      INTO ITEM_DISPLAY_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
        AND LOOKUP_CODE = P_FLEX_OR_DESC;

Line: 256

      SELECT
        LINE_ID
      INTO LINE_ID
      FROM
        OE_ORDER_HOLDS
      WHERE ORDER_HOLD_ID = P_ORDER_HOLD_ID;

Line: 280

        SELECT
          HEADER_ID
        INTO HEADER_ID_VAR
        FROM
          OE_ORDER_HOLDS
        WHERE HEADER_ID = HEADER_ID
          AND LINE_ID is NULL
          AND HOLD_RELEASE_ID is NULL;

Line: 306

    SELECT
      NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
                                 ,MO_GLOBAL.GET_CURRENT_ORG_ID)
         ,0)
    INTO V_MASTER_ORG
    FROM
      DUAL;