APPS.PO_POXRRVDR_XMLP_PKG SQL Statements

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

Line: 15

        SELECT
          ORGANIZATION_NAME
        INTO
          L_ORG
        FROM
          ORG_ORGANIZATION_DEFINITIONS
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 26

      SELECT
        CURRENCY_CODE
      INTO
        L_CURRENCY_CODE
      FROM
        GL_SETS_OF_BOOKS GSB,
        FINANCIALS_SYSTEM_PARAMETERS FSP
      WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID;

Line: 110

      SELECT
        PRECISION
      INTO
        L_DOC_CURR_PRECISION
      FROM
        FND_CURRENCIES
      WHERE CURRENCY_CODE = CURRENCY_CODE;

Line: 183

        SELECT
          CATEGORY_SET_NAME
        INTO
          CAT_SET_NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = CAT_SET_ID;

Line: 222

    SELECT
      STRUCTURE_ID
    INTO
      L_P_STRUCT_NUM
    FROM
      MTL_DEFAULT_SETS_VIEW
    WHERE FUNCTIONAL_AREA_ID = 2;

Line: 286

        SELECT
          PSP.MANUAL_RECEIPT_NUM_TYPE
        INTO
          RECEIPT_NUMBERING_TYPE
        FROM
          PO_SYSTEM_PARAMETERS PSP;

Line: 295

        SELECT
          DISTINCT
          MANUAL_RECEIPT_NUM_TYPE
        INTO
          RECEIPT_NUMBERING_TYPE
        FROM
          RCV_RECEIVING_PARAMETERS_V
        WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 341

      SELECT
        NVL((SUM(NVL(PO_TAX_SV.GET_TAX('PO'
                                     ,POD.PO_DISTRIBUTION_ID)
                   ,0)) / SUM(POD.QUANTITY_ORDERED))
           ,0)
      INTO
        L_TOT_TAX
      FROM
        PO_DISTRIBUTIONS_ALL POD,
        RCV_TRANSACTIONS RT
      WHERE RT.TRANSACTION_ID = TRX_ID
        AND ( ( RT.PO_DISTRIBUTION_ID IS NOT NULL
        AND RT.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID )
      OR ( RT.PO_DISTRIBUTION_ID IS NULL
        AND RT.PO_LINE_LOCATION_ID = POD.LINE_LOCATION_ID ) );

Line: 356

      SELECT
        DECODE(SIGN(NVL(SUM(ACCOUNTED_NR_TAX)
                       ,0))
              ,0
              ,0
              ,1) * L_TOT_TAX
      INTO
        L_TOT_TAX
      FROM
        RCV_RECEIVING_SUB_LEDGER
      WHERE RCV_TRANSACTION_ID = TRX_ID;