APPS.GMI_RIWIN_XMLP_PKG SQL Statements

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

Line: 7

    SELECT
      SUM(LOCT_ONHAND)
    INTO WHSEQTY
    FROM
      IC_ITEM_MST ITM,
      IC_LOCT_INV ILI
    WHERE ITM.ITEM_ID = ILI.ITEM_ID
      AND ILI.DELETE_MARK = 0
      AND ITM.DELETE_MARK = 0
      AND ILI.WHSE_CODE = WHSCODE
      AND ITM.ITEM_ID = WHSE_QTYFORMULA.ITEM_ID;

Line: 24

    SELECT
      SUM(LOCT_ONHAND)
    INTO TOTALQTY
    FROM
      IC_ITEM_MST ITM,
      IC_LOCT_INV ILI
    WHERE ITM.ITEM_ID = ILI.ITEM_ID
      AND ILI.DELETE_MARK = 0
      AND ITM.DELETE_MARK = 0
      AND ITM.ITEM_ID = TOTAL_QTYFORMULA.ITEM_ID;

Line: 45

    SELECT
      NVL(SUM(LOCT_ONHAND2),0)
    INTO WHSEQTY2
    FROM
      IC_ITEM_MST ITM,
      IC_LOCT_INV ILI
    WHERE ITM.ITEM_ID = ILI.ITEM_ID
      AND ILI.DELETE_MARK = 0
      AND ITM.DELETE_MARK = 0
      AND ILI.WHSE_CODE = WHSCODE
      AND ITM.ITEM_ID = WHSE_QTY2FORMULA.ITEM_ID;

Line: 62

    SELECT
      NVL(SUM(LOCT_ONHAND2),0)
    INTO TOTALQTY2
    FROM
      IC_ITEM_MST ITM,
      IC_LOCT_INV ILI
    WHERE ITM.ITEM_ID = ILI.ITEM_ID
      AND ILI.DELETE_MARK = 0
      AND ITM.DELETE_MARK = 0
      AND ITM.ITEM_ID = TOTAL_QTY2FORMULA.ITEM_ID;

Line: 82

    SELECT
      DECODE(FROM_ITEM
            ,NULL
            ,DECODE(TO_ITEM
                  ,NULL
                  ,'Item Range : All '
                  ,'Item Range : All - ' || TO_ITEM)
            ,DECODE(TO_ITEM
                  ,NULL
                  ,'Item Range : ' || FROM_ITEM || ' - All '
                  ,'Item Range : ' || FROM_ITEM || ' - ' || TO_ITEM))
    INTO RANGEV
    FROM
      DUAL;

Line: 102

    SELECT
      USER_NAME
    INTO USERNAME
    FROM
      FND_USER
    WHERE USER_ID = GMI_RIWIN_XMLP_PKG.USER_ID;

Line: 114

      SELECT
        'All'
      INTO FROM_ITEMCP
      FROM
        DUAL;

Line: 128

      SELECT
        'All'
      INTO TO_ITEMCP
      FROM
        DUAL;

Line: 142

      SELECT
        'All'
      INTO TO_WHSECP
      FROM
        DUAL;

Line: 156

      SELECT
        'All'
      INTO FROM_WHSECP
      FROM
        DUAL;