APPS.GML_PORIRUSR_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        COUNT(RECV_NO)
      INTO CP_ROWS
      FROM
        IC_ITEM_MST IM,
        PO_RECV_HDR RH,
        PO_RECV_DTL RD,
        IC_TRAN_PND TP
      WHERE IM.ITEM_ID = RD.ITEM_ID
        AND RH.RECV_ID = RD.RECV_ID
        AND RH.DELETE_MARK = 0
        AND TRUNC(RD.RECV_DATE) between TRUNC(P_RECV_DATE_FROM)
        AND TRUNC(P_RECV_DATE_TO)
        AND IM.ITEM_NO between P_ITEM_NO_FROM
        AND P_ITEM_NO_TO
        AND RD.TO_WHSE between P_TO_WHSE_FROM
        AND P_TO_WHSE_TO
        AND TP.DOC_TYPE = 'RECV'
        AND TP.DOC_ID = RH.RECV_ID
        AND TP.LINE_ID = RD.LINE_ID
        AND TP.TRANS_QTY > 0;

Line: 42

    SELECT
      LOT_NO
    INTO V_LOT
    FROM
      IC_LOTS_MST LM
    WHERE LM.ITEM_ID = LOT_NOFORMULA.ITEM_ID
      AND LM.LOT_ID = LOT_NOFORMULA.LOT_ID;

Line: 60

    SELECT
      SUBLOT_NO
    INTO V_SUBLOT
    FROM
      IC_LOTS_MST LM
    WHERE LM.ITEM_ID = SUBLOT_NOFORMULA.ITEM_ID
      AND LM.LOT_ID = SUBLOT_NOFORMULA.LOT_ID;

Line: 76

    CURSOR CUR_SELECT IS
      SELECT
        MEANING
      FROM
        GEM_LOOKUP_VALUES
      WHERE LOOKUP_CODE = P_SORT_BY
        AND LOOKUP_TYPE = 'SORT_OPTIONS1_GEMMSPO';

Line: 84

    OPEN CUR_SELECT;

Line: 85

    FETCH CUR_SELECT
     INTO X_SORT1;

Line: 87

    CLOSE CUR_SELECT;