APPS.ZX_ZXAPJAJL_XMLP_PKG SQL Statements

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

Line: 20

    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: 63

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

Line: 70

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

Line: 77

    SELECT
      L1.DISPLAYED_FIELD,
      L2.DISPLAYED_FIELD,
      L3.DISPLAYED_FIELD
    INTO CP_NLS_ALL,CP_NLS_VOID,CP_NLS_NA
    FROM
      AP_LOOKUP_CODES L1,
      AP_LOOKUP_CODES L2,
      AP_LOOKUP_CODES L3
    WHERE L1.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND L1.LOOKUP_CODE = 'ALL'
      AND L2.LOOKUP_TYPE = 'NLS TRANSLATION'
      AND L2.LOOKUP_CODE = 'VOID'
      AND L3.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND L3.LOOKUP_CODE = 'NA';

Line: 122

        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: 129

        SELECT
          LEDGER_NAME
        INTO P_COMPANY_NAME_DESC
        FROM
          GL_LEDGER_LE_V
        WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 136

        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: 310

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

Line: 406

      SELECT
        SUM(A.TAXABLE_AMT)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_INVOICE_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: 445

      SELECT
        SUM(A.TAXABLE_AMT_FUNCL_CURR)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_INVOICE_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: 461

      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_INVOICE_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: 499

    SELECT
      VENDOR_NAME
    INTO L_VENDOR_NAME
    FROM
      PO_VENDORS
    WHERE VENDOR_ID = P_SUPPLIER_NAME;

Line: 516

      SELECT
        CURRENCY_CODE
      INTO L_LEDGER_CURRENCY
      FROM
        GL_LEDGERS
      WHERE LEDGER_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 523

      SELECT
        CURRENCY_CODE
      INTO L_LEDGER_CURRENCY
      FROM
        GL_LEDGER_LE_V
      WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;

Line: 530

      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;