APPS.GML_GMLUNALC_XMLP_PKG SQL Statements

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

Line: 109

        SELECT
          SUM(NVL(TRANS_QTY
                 ,0)),
          SUM(NVL(TRANS_QTY2
                 ,0))
        FROM
          IC_TRAN_PND
        WHERE ITEM_ID = CF_1FORMULA.ITEM_ID
          AND WHSE_CODE = CF_1FORMULA.WHSE_CODE
          AND COMPLETED_IND = 0
          AND DELETE_MARK = 0
          AND DOC_TYPE = 'OMSO'
          AND QC_GRADE = CF_1FORMULA.QC_GRADE
          AND ( LOT_ID <> 0
        OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );

Line: 125

        SELECT
          SUM(NVL(TRANS_QTY
                 ,0)),
          SUM(NVL(TRANS_QTY2
                 ,0))
        FROM
          IC_TRAN_PND
        WHERE ITEM_ID = CF_1FORMULA.ITEM_ID
          AND WHSE_CODE = CF_1FORMULA.WHSE_CODE
          AND COMPLETED_IND = 0
          AND DELETE_MARK = 0
          AND ( LOT_ID <> 0
        OR LOCATION <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT') );

Line: 139

        SELECT
          SUM(NVL(S.ONHAND_ORDER_QTY
                 ,0)),
          SUM(NVL(S.ONHAND_ORDER_QTY2
                 ,0)),
          SUM(NVL(S.COMMITTEDSALES_QTY
                 ,0)),
          SUM(NVL(S.COMMITTEDSALES_QTY2
                 ,0))
        FROM
          IC_SUMM_INV S
        WHERE S.ITEM_ID = CF_1FORMULA.ITEM_ID
          AND S.WHSE_CODE = CF_1FORMULA.WHSE_CODE;

Line: 153

        SELECT
          SUM(NVL(S.ONHAND_ORDER_QTY
                 ,0)),
          SUM(NVL(S.ONHAND_ORDER_QTY2
                 ,0)),
          SUM(NVL(S.COMMITTEDSALES_QTY
                 ,0)),
          SUM(NVL(S.COMMITTEDSALES_QTY2
                 ,0))
        FROM
          IC_SUMM_INV S
        WHERE S.ITEM_ID = CF_1FORMULA.ITEM_ID
          AND S.WHSE_CODE = CF_1FORMULA.WHSE_CODE
          AND S.QC_GRADE = CF_1FORMULA.QC_GRADE;

Line: 168

        SELECT
          GRADE_CTL
        FROM
          IC_ITEM_MST
        WHERE ITEM_ID = CF_1FORMULA.ITEM_ID;

Line: 174

        SELECT
          ITEM_UM
        FROM
          IC_ITEM_MST
        WHERE ITEM_ID = CF_1FORMULA.ITEM_ID;

Line: 231

      SELECT
        UM_CODE
      INTO L_ORDER_UM
      FROM
        SY_UOMS_MST
      WHERE UOM_CODE = CF_1FORMULA.UOM;

Line: 258

      SELECT
        MEANING
      INTO CP_SORT_1
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_1;

Line: 267

      SELECT
        MEANING
      INTO CP_SORT_2
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_2;

Line: 276

      SELECT
        MEANING
      INTO CP_SORT_3
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_3;

Line: 285

      SELECT
        MEANING
      INTO CP_SORT_4
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_4;

Line: 303

    SELECT
      NAME
    INTO CP_ORGN_NAME
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID');

Line: 309

    SELECT
      USER_NAME
    INTO CP_USER
    FROM
      FND_USER
    WHERE P_DEFAULT_USER = USER_ID;

Line: 316

      SELECT
        MEANING
      INTO CP_SORT_1
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_1;

Line: 325

      SELECT
        MEANING
      INTO CP_SORT_2
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_2;

Line: 334

      SELECT
        MEANING
      INTO CP_SORT_3
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_3;

Line: 343

      SELECT
        MEANING
      INTO CP_SORT_4
      FROM
        GEM_LOOKUPS
      WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
        AND LOOKUP_CODE = P_SORT_4;

Line: 383

        SELECT
          ITEM_UM
        FROM
          IC_ITEM_MST
        WHERE ITEM_ID = CF_UNALLOCATED_INVENTORYFORMUL.ITEM_ID;

Line: 389

        SELECT
          PND.LINE_ID
        FROM
          IC_TRAN_PND PND
        WHERE PND.DOC_TYPE = 'OMSO'
          AND PND.COMPLETED_IND = 0
          AND PND.DELETE_MARK = 0
          AND PND.TRANS_QTY < 0
          AND LINE_ID = CF_UNALLOCATED_INVENTORYFORMUL.LINE_ID;

Line: 421

        SELECT
          UM_CODE
        INTO L_ORDER_UM
        FROM
          SY_UOMS_MST
        WHERE UOM_CODE = UOM;