APPS.GML_ORAKRP_XMLP_PKG SQL Statements

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

Line: 8

    SELECT
      DISTINCT
      CHRGMST.CHARGE_DESC,
      ORDRCHG.EXTENDED_AMOUNT
    INTO FLD1,FLD2
    FROM
      OP_CHRG_MST CHRGMST,
      OP_ORDR_CHG ORDRCHG
    WHERE ORDRCHG.LINE_ID = LINE_ID
      AND CHRGMST.CHARGE_ID = ORDRCHG.CHARGE_ID
      AND ORDRCHG.ORDER_ID = ORDER_ID
      AND ORDRCHG.DELETE_MARK = 0
      AND ORDRCHG.BILLABLE_IND = 1
      AND ORDRCHG.LINE_ID = 0;

Line: 34

      SELECT
        ORGN_NAME
      FROM
        SY_ORGN_MST
      WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;

Line: 51

    SELECT
      ORGN_NAME
    INTO CP_ORGN_NAME
    FROM
      SY_ORGN_MST
    WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;

Line: 57

    SELECT
      USER_NAME
    INTO CP_USER
    FROM
      FND_USER
    WHERE USER_ID = DEFAULT_USER;

Line: 111

      SELECT
        DISTINCT
        ORDRCHG.EXTENDED_AMOUNT
      INTO EXT_AMT
      FROM
        OP_CHRG_MST CHRGMST,
        OP_ORDR_CHG ORDRCHG
      WHERE CHRGMST.CHARGE_ID = ORDRCHG.CHARGE_ID
        AND ORDRCHG.DELETE_MARK = 0
        AND ORDRCHG.BILLABLE_IND = 1
        AND ORDRCHG.LINE_ID = LINE_ID
        AND ORDRCHG.ORDER_ID = ORDER_ID;

Line: 337

    SELECT
      TERMS_DESC
    INTO CODE
    FROM
      OP_TERM_MST
    WHERE TERMS_CODE = TERMS;

Line: 369

      'UPDATE OP_ORDR_HDR SET PRINT_COUNT=PRINT_COUNT+1,DATE_PRINTED=SYSDATE ' || 'WHERE ORDER_TYPE=:a ' ||
      'AND ORDER_NO = :b ' || 'AND RELEASE_NO=:c ' || 'AND ORGN_CODE=:d ' ||
      'AND PRINT_COUNT < ' || TO_CHAR(X_PRINT_COUNT)
      using ORDER_TYPE, O_NO, RELEASE_NO, GML_ORAKRP_XMLP_PKG.ORGN_CODE ;

Line: 382

      SELECT
        NVL(SUM(EXTENDED_AMOUNT)
           ,0)
      INTO EXT_AMT
      FROM
        OP_ORDR_CHG C
      WHERE C.ORDER_ID = ORDER_ID
        AND C.LINE_ID = LINE_ID
        AND C.DELETE_MARK = 0
        AND C.EXTENDED_AMOUNT > 0;

Line: 404

      SELECT
        NVL(ABS(SUM(EXTENDED_AMOUNT))
           ,0)
      INTO EXT_AMT
      FROM
        OP_ORDR_CHG C
      WHERE C.ORDER_ID = ORDER_ID
        AND C.LINE_ID = LINE_ID
        AND C.DELETE_MARK = 0
        AND C.EXTENDED_AMOUNT < 0;

Line: 425

      SELECT
        NVL(SUM(EXTENDED_AMOUNT)
           ,0)
      INTO EXT_AMT
      FROM
        OP_ORDR_CHG C
      WHERE C.ORDER_ID = ORDER_ID
        AND C.LINE_ID IS NULL
        AND C.DELETE_MARK = 0
        AND C.EXTENDED_AMOUNT > 0;

Line: 446

      SELECT
        NVL(ABS(SUM(EXTENDED_AMOUNT))
           ,0)
      INTO EXT_AMT
      FROM
        OP_ORDR_CHG C
      WHERE C.ORDER_ID = ORDER_ID
        AND C.LINE_ID IS NULL
        AND C.DELETE_MARK = 0
        AND C.EXTENDED_AMOUNT < 0;

Line: 469

      SELECT
        NVL(SUM(EXTENDED_AMOUNT)
           ,0)
      INTO EXT_AMT_CHARGE
      FROM
        OP_ORDR_CHG C
      WHERE C.ORDER_ID = ORD_TOT_FORMULA.ORDER_ID
        AND C.DELETE_MARK = 0;

Line: 477

      SELECT
        NVL(SUM(EXTENDED_PRICE)
           ,0)
      INTO EXT_AMT_LINES
      FROM
        OP_ORDR_DTL D
      WHERE D.ORDER_ID = ORD_TOT_FORMULA.ORDER_ID
        AND D.DELETE_MARK = 0
        AND D.LINE_STATUS <> - 1;