eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ARXPIREP_XMLP_PKG SQL Statements

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

Line: 59


      SELECT
        MEANING
      INTO POSTED_DESCRIPTION
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'POSTED_STATUS'
        AND LOOKUP_CODE = 'BOTH';

Line: 76


      SELECT
        CONCATENATED_SEGMENT_DELIMITER
      INTO DELIM
      FROM
        FND_ID_FLEX_STRUCTURES
      WHERE ID_FLEX_CODE = 'GL#'
        AND ID_FLEX_NUM = COA_ID;

Line: 94


      SELECT
        FLEX_VALUE_SET_ID
      INTO BAL_VS_ID
      FROM
        FND_ID_FLEX_SEGMENTS
      WHERE ID_FLEX_CODE = 'GL#'
        AND ID_FLEX_NUM = COA_ID
        AND ENABLED_FLAG = 'Y'
        AND APPLICATION_COLUMN_NAME = SUBSTR(ACCT_FLEX_BAL_SEG
            ,INSTR(ACCT_FLEX_BAL_SEG
                 ,'.') + 1);

Line: 174


    select argument1,argument2,argument3,argument4,argument5,to_date(substr(argument6,1,10),'YYYY/MM/DD'),to_date(substr(argument7,1,10),'YYYY/MM/DD'),argument8,argument9,argument10,argument11
    into P_BAL_HIGH,P_BAL_LOW,P_CA_SET_OF_BOOKS_ID,P_COAID,P_CURRENCY_CODE,P_HIGH_DATE,P_LOW_DATE,P_MIN_PRECISION,P_MRCSOBTYPE,P_REPORTING_ENTITY_ID,P_REPORTING_LEVEL
    from fnd_concurrent_requests
    where request_id = P_CONC_REQUEST_ID;

Line: 191


        SELECT
          MRC_SOB_TYPE_CODE
        INTO P_MRCSOBTYPE
        FROM
          GL_SETS_OF_BOOKS
        WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;

Line: 303


    LP_ADJ_SELECT := 'Select ''ADJ_ADJ'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''Y'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                     union all
                     Select ''ADJ_ADJ_NON_REC_TAX'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''Y'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                     union all
                     Select ''ADJ_FINCHRG'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                     union all
                     Select ''ADJ_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 310


    LP_CB_SELECT := 'Select ''CB_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''CB_REV'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                    union all
                    Select ''CB_UNBILL'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''CB_UNEARN'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 317


    LP_CM_SELECT := 'Select ''CM_CHARGES'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                    union all
                    Select ''CM_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''CM_REV'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                    union all
                    Select ''CM_UNBILL'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''CM_UNEARN'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 326


    LP_DM_SELECT := 'Select ''DM_CHARGES'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                    union all
                    Select ''DM_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''DM_REV'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                    union all
                    Select ''DM_UNBILL'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                    union all
                    Select ''DM_UNEARN'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 335


    LP_INV_SELECT := 'Select ''INV_CHARGES'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                     union all
                     Select ''INV_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                     union all
                     Select ''INV_REV'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''Y'' REVENUE_TYPE from dual
                     union all
                     Select ''INV_UNBILL'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                     union all
                     Select ''INV_UNEARN'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 344


    LP_MISC_SELECT := 'Select ''MISC_CASH'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                      union all
                      Select ''MISC_CONFIRMATION'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                      union all
                      Select ''MISC_REMITTANCE'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                      union all
                      Select ''MISC_SHORT_TERM_DEBT'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual ';

Line: 351


    LP_TRADE_SELECT := 'Select ''TRADE_ACC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_CASH'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_CONFIRMATION'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_EDISC_NON_REC_TAX'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''Y'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_REC'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_REMITTANCE'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_SHORT_TERM_DEBIT'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''Y'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_UNAPP'' JOURNAL_CATEGORY ,''Y'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''N'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual
                       union all
                       Select ''TRADE_UNEDISC_NON_REC_TAX'' JOURNAL_CATEGORY ,''N'' ASSET_TYPE ,''N'' LIABILITY_TYPE ,''Y'' EXPENSE_TYPE ,''N'' REVENUE_TYPE from dual';

Line: 403


    SELECT
      MEANING
    INTO W_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
      AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 468


      SELECT
        MEANING
      INTO L_POSTED_STATUS
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'POSTED_STATUS'
        AND LOOKUP_CODE = 'BOTH';