APPS.ARRX_RC SQL Statements

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

Line: 155

   select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
   into var.chart_of_accounts_id,var.currency_code,var.org_name
   from GL_SETS_OF_BOOKS
   where SET_OF_BOOKS_ID = var.books_id;

Line: 623

     select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
     into var.p_coa_id,var.functional_currency_code,var.organization_name
     from GL_SETS_OF_BOOKS
     where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);

Line: 705

                         SELECT NVL(MAX(CRHNEW.CASH_RECEIPT_HISTORY_ID ), MAX(INCRH.CASH_RECEIPT_HISTORY_ID))
                               FROM AR_CASH_RECEIPT_HISTORY INCRH ,
                                    AR_CASH_RECEIPT_HISTORY CRHNEW
                              WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
                              AND   CRHNEW.CASH_RECEIPT_ID(+) = INCRH.CASH_RECEIPT_ID
                              AND   CRHNEW.CURRENT_RECORD_FLAG(+) = ''Y'' ' ||
			      INCRH_GL_DATE_WHERE ||
                             CRHNEW_GL_DATE_WHERE || ')
                            AND CRHLAST.CASH_RECEIPT_HISTORY_ID  = (
                                 SELECT nvl(MAX(INCRH2.CASH_RECEIPT_HISTORY_ID),CRH.CASH_RECEIPT_HISTORY_ID)
                                   FROM AR_CASH_RECEIPT_HISTORY INCRH2
                                  WHERE INCRH2.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID '||
                                  ' AND INCRH2.GL_DATE < :c_gl_date_low)
                            AND CRH.CASH_RECEIPT_ID = CRHLAST.CASH_RECEIPT_ID
                       AND (decode(CRHLAST.CASH_RECEIPT_HISTORY_ID , CRH.CASH_RECEIPT_HISTORY_ID, CRH.ACCTD_AMOUNT +1
                                   , CRHLAST.ACCTD_AMOUNT) <> CRH.ACCTD_AMOUNT
                           OR decode(CRHLAST.CASH_RECEIPT_HISTORY_ID , CRH.CASH_RECEIPT_HISTORY_ID,NVL( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0) + 1
                                 ,nvl(CRHLAST.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)) <>nvl( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)
                           OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;

Line: 729

                         SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
                           FROM AR_CASH_RECEIPT_HIST_ALL_MRC_V INCRH
                          WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
                            AND INCRH.GL_DATE BETWEEN :p_gl_date_low AND :p_gl_date_high)
                            AND CRHLAST.CASH_RECEIPT_HISTORY_ID  = (
                                 SELECT nvl(MAX(INCRH2.CASH_RECEIPT_HISTORY_ID),CRH.CASH_RECEIPT_HISTORY_ID)
                                   FROM AR_CASH_RECEIPT_HIST_MRC_V INCRH2
                                  WHERE INCRH2.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID '||
                                  ' AND INCRH2.GL_DATE < :c_gl_date_low)
				  AND CRH.CASH_RECEIPT_ID = CRHLAST.CASH_RECEIPT_HISTORY_ID
                       AND (decode(CRHLAST.CASH_RECEIPT_HISTORY_ID , CRH.CASH_RECEIPT_HISTORY_ID, CRH.ACCTD_AMOUNT +1
                                   , CRHLAST.ACCTD_AMOUNT) <> CRH.ACCTD_AMOUNT
                           OR decode(CRHLAST.CASH_RECEIPT_HISTORY_ID , CRH.CASH_RECEIPT_HISTORY_ID,NVL( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0) + 1
                                 ,nvl(CRHLAST.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)) <>nvl( CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT,0)
                           OR CRH.STATUS=''REVERSED'')' || CO_SEG_WHERE;

Line: 1148

                                 SELECT NVL(CRHNEW.CASH_RECEIPT_HISTORY_ID, INCRH.CASH_RECEIPT_HISTORY_ID)
                                 FROM AR_CASH_RECEIPT_HISTORY INCRH ,
                                 AR_CASH_RECEIPT_HISTORY CRHNEW
                                 WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
                                 AND   INCRH.FIRST_POSTED_RECORD_FLAG = ''Y''
                                 AND   CRHNEW.CASH_RECEIPT_ID(+) = INCRH.CASH_RECEIPT_ID
                                 AND   CRHNEW.CURRENT_RECORD_FLAG(+) = ''Y''
                                 AND   CRHNEW.STATUS(+) <> ''REVERSED''
                                 AND   INCRH.STATUS <> ''REVERSED'' ' ||
                                 INCRH_GL_DATE_WHERE ||
                                 CRHNEW_GL_DATE_WHERE ||
                                 ' ))) ' ||
                     CO_SEG_WHERE ||' ' ||
                     MCD_GL_DATE_WHERE || ' ';

Line: 1279

   select MEANING into L_CASH       from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE'   and lookup_code='CASH';

Line: 1280

   select MEANING into L_MISC       from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE'   and lookup_code='MISC';

Line: 1281

   select MEANING into var.l_app    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='APP';

Line: 1282

   select MEANING into var.l_nsf    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='NSF';

Line: 1283

   select MEANING into var.l_rev    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='REV';

Line: 1284

   select MEANING into var.l_stop   from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='STOP';

Line: 1285

   select MEANING into var.l_unapp  from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='UNAPP';

Line: 1286

   select MEANING into var.l_unid   from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='UNID';

Line: 1287

   select MEANING into L_PAYMENT    from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='PAYMENT';

Line: 1288

   select MEANING into L_RECEIPT    from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='RECEIPT';

Line: 1289

   select MEANING into L_REMITTANCE from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='REMITTANCE';

Line: 1290

   select MEANING into L_APPROVED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';

Line: 1291

   select MEANING into L_CLEARED    from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';

Line: 1292

   select MEANING into L_CONFIRMED  from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';

Line: 1293

   select MEANING into L_REMITTED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';

Line: 1294

   select MEANING into L_REVERSED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';

Line: 1317

      select MEANING into L_ACCO   from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='ACC';

Line: 1318

      select MEANING into L_APPL   from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';

Line: 1319

      select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';

Line: 1320

      select MEANING into L_UNIDE  from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';

Line: 1332

      SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';

Line: 1373

         select decode(
                    sum(decode(status,'UNID', amount_applied,0)),
                    0,
                    decode(sum(decode(status,'UNAPP', amount_applied,0))
                    , 0 , var.l_app , var.l_unapp),
                    var.l_unid)
         into var.receipt_status
         from ar_receivable_applications
         where cash_receipt_id = var.cash_receipt_id;

Line: 1386

        select decode(
                    sum(decode(status,'UNID', amount_applied,0)),
                    0,
                    decode(sum(decode(status,'UNAPP', amount_applied,0))
                    , 0 , var.l_app , var.l_unapp),
                    var.l_unid)
        into var.receipt_status
        from ar_receivable_apps_mrc_v
        where cash_receipt_id = var.cash_receipt_id;

Line: 1531

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1573

    select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
    into  l_client_info_rsob_id
    from  dual;

Line: 1596

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1689

    select set_of_books_id
     into   var.books_id
     from  ar_system_parameters_all
     where org_id = var.p_reporting_entity_id;

Line: 1699

   select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
   into  l_client_info_rsob_id from  dual;

Line: 1723

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1793

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1834

  SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
  INTO l_client_info_rsob_id
  FROM dual;

Line: 1858

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1940

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1962

                'arrx_rc.bind(:CURSOR_SELECT);',