DBA Data[Home] [Help]

APPS.IBY_TRXN_EXTENSIONS_PKG SQL Statements

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

Line: 27

        SELECT
          TRXN_EXTENSION_ID,
          PAYMENT_CHANNEL_CODE,
          INSTR_ASSIGNMENT_ID,
          INSTRUMENT_SECURITY_CODE,
          VOICE_AUTHORIZATION_FLAG,
          VOICE_AUTHORIZATION_DATE,
          VOICE_AUTHORIZATION_CODE,
          ORIGIN_APPLICATION_ID,
          ORDER_ID,
          PO_NUMBER,
          PO_LINE_NUMBER,
          TRXN_REF_NUMBER1,
          TRXN_REF_NUMBER2,
          ADDITIONAL_INFO
        FROM IBY_FNDCPT_TX_EXTENSIONS
        WHERE  TRXN_EXTENSION_ID = X_TRXN_EXTENSION_ID
        FOR UPDATE of TRXN_EXTENSION_ID NOWAIT;
Line: 55

    debug_info := 'Select from IBY_TRXN_EXTENSIONS_V';
Line: 64

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');