APPS.ZX_ZXARRECV_XMLP_PKG SQL Statements

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

Line: 54

    SELECT
      COUNT(1)
    INTO CP_TRL_ROW_COUNT
    FROM
      ZX_REP_CONTEXT_T CON,
      ZX_REP_TRX_DETAIL_T DET
    WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
      AND DET.REQUEST_ID = CON.REQUEST_ID
      AND NVL(DET.REP_CONTEXT_ID
       ,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;

Line: 65

      SELECT
        GL.SET_OF_BOOKS_ID
      INTO L_SET_OF_BOOKS_ID
      FROM
        GL_SETS_OF_BOOKS GL,
        AR_SYSTEM_PARAMETERS AR
      WHERE GL.SET_OF_BOOKS_ID = AR.SET_OF_BOOKS_ID;

Line: 72

      SELECT
        GL.PERIOD_NAME
      INTO L_PERIOD_FROM
      FROM
        GL_PERIOD_STATUSES GL,
        AR_SYSTEM_PARAMETERS AR
      WHERE GL.START_DATE = P_GL_DATE_LOW
        AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
        AND GL.APPLICATION_ID = 222
        AND ROWNUM = 1;

Line: 82

      SELECT
        GL.PERIOD_NAME
      INTO L_PERIOD_TO
      FROM
        GL_PERIOD_STATUSES GL,
        AR_SYSTEM_PARAMETERS AR
      WHERE GL.END_DATE = P_GL_DATE_HIGH
        AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
        AND GL.APPLICATION_ID = 222
        AND ROWNUM = 1;

Line: 110

        SELECT
          MEANING
        INTO L_DETAIL_LEVEL
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'ARXVATRN_DETAIL_OPTION'
          AND LOOKUP_CODE = P_DETAIL_LEVEL;

Line: 145

        SELECT
          SOB.NAME
        INTO P_COMPANY_NAME_DESC
        FROM
          GL_SETS_OF_BOOKS SOB
        WHERE SET_OF_BOOKS_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 152

        SELECT
          LEDGER_NAME
        INTO P_COMPANY_NAME_DESC
        FROM
          GL_LEDGER_LE_V
        WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 159

        SELECT
          SOB.NAME
        INTO P_COMPANY_NAME_DESC
        FROM
          HR_OPERATING_UNITS HR,
          GL_SETS_OF_BOOKS SOB
        WHERE HR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
          AND HR.ORGANIZATION_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 218

    SELECT
      MEANING
    INTO CP_NLS_YES
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = 'Y';

Line: 225

    SELECT
      MEANING
    INTO CP_NLS_NO
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = 'N';

Line: 404

    SELECT
      MEANING
    INTO CP_REPORT_TITLE
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'ZXARRECV'
      AND LOOKUP_CODE = P_REPORT_NAME;

Line: 456

          SELECT
            'SUCCESS'
          INTO L_DUMMY
          FROM
            JG_ZZ_AR_SRC_TRX_TY ST,
            RA_BATCH_SOURCES SRC
          WHERE ST.BATCH_SOURCE_ID = DECODE(SRC.GLOBAL_ATTRIBUTE1
                ,NULL
                ,SRC.BATCH_SOURCE_ID
                ,SRC.GLOBAL_ATTRIBUTE1)
            AND SRC.NAME = TRX_SOURCE
            AND ST.ENABLE_FLAG = 'Y';

Line: 546

      SELECT
        SUM(A.TAXABLE_AMT)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_TRANSACTION_ID
        AND A.TRX_LINE_ID = C_TRANSACTION_LINE
        AND A.REQUEST_ID = P_CONC_REQUEST_ID
        AND A.ROWID = (
        SELECT
          MIN(B.ROWID)
        FROM
          ZX_REP_TRX_DETAIL_T B
        WHERE A.TRX_ID = B.TRX_ID
          AND A.TRX_LINE_ID = B.TRX_LINE_ID
          AND B.REQUEST_ID = P_CONC_REQUEST_ID );

Line: 585

      SELECT
        SUM(A.TAXABLE_AMT_FUNCL_CURR)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_TRANSACTION_ID
        AND A.TRX_LINE_ID = C_TRANSACTION_LINE
        AND A.REQUEST_ID = P_CONC_REQUEST_ID
        AND A.ROWID = (
        SELECT
          MIN(B.ROWID)
        FROM
          ZX_REP_TRX_DETAIL_T B
        WHERE A.TRX_ID = B.TRX_ID
          AND A.TRX_LINE_ID = B.TRX_LINE_ID
          AND B.REQUEST_ID = P_CONC_REQUEST_ID );

Line: 601

      SELECT
        SUM(NVL(A.TAXABLE_AMT
               ,0) + NVL(A.TAX_AMT
               ,0)),
        SUM(NVL(A.TAXABLE_AMT_FUNCL_CURR
               ,0) + NVL(A.TAX_AMT_FUNCL_CURR
               ,0))
      INTO CF_TOT_AMOUNT,CF_TOT_FUNC_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_TRANSACTION_ID
        AND A.TRX_LINE_ID = C_TRANSACTION_LINE
        AND A.REQUEST_ID = P_CONC_REQUEST_ID
        AND A.ROWID = (
        SELECT
          MIN(B.ROWID)
        FROM
          ZX_REP_TRX_DETAIL_T B
        WHERE A.TRX_ID = B.TRX_ID
          AND A.TRX_LINE_ID = B.TRX_LINE_ID
          AND B.REQUEST_ID = P_CONC_REQUEST_ID );

Line: 640

      SELECT
        PARTY.PARTY_NAME
      INTO L_CUST_NAME
      FROM
        HZ_CUST_ACCOUNTS CUST,
        HZ_PARTIES PARTY
      WHERE CUST.PARTY_ID = PARTY.PARTY_ID
        AND CUST.CUST_ACCOUNT_ID = P_CUSTOMER_ID;

Line: 670

      SELECT
        CURRENCY_CODE
      INTO L_LEDGER_CURRENCY
      FROM
        GL_LEDGERS
      WHERE LEDGER_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 677

      SELECT
        CURRENCY_CODE
      INTO L_LEDGER_CURRENCY
      FROM
        GL_LEDGER_LE_V
      WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 684

      SELECT
        B.CURRENCY_CODE
      INTO L_LEDGER_CURRENCY
      FROM
        HR_OPERATING_UNITS A,
        GL_LEDGERS B
      WHERE A.SET_OF_BOOKS_ID = B.LEDGER_ID
        AND A.ORGANIZATION_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 843

        GUI_TABLE.DELETE;