APPS.JA_JAINSTAC_XMLP_PKG SQL Statements

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

Line: 10

    SELECT
      SUM((API.INVOICE_AMOUNT - NVL(AMOUNT_PAID
             ,0)) * NVL(EXCHANGE_RATE
             ,1)) AMOUNT
    INTO V_AMOUNT
    FROM
      AP_INVOICES_ALL API
    WHERE API.VENDOR_ID = VEND_ID
      AND TRUNC(API.INVOICE_DATE) BETWEEN TRUNC(DT1)
      AND TRUNC(DT2)
      AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )
      AND API.INVOICE_TYPE_LOOKUP_CODE <> LV_PREPAYMENT
      AND ( API.ORG_ID = P_ORG_ID
    OR API.ORG_ID IS NULL );

Line: 32

    SELECT
      SUM((API.INVOICE_AMOUNT - NVL(AMOUNT_PAID
             ,0)) * NVL(EXCHANGE_RATE
             ,1)) AMOUNT
    INTO V_AMOUNT
    FROM
      AP_INVOICES_ALL API
    WHERE API.VENDOR_ID = VEND_ID
      AND TRUNC(API.INVOICE_DATE) < TRUNC(DT)
      AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )
      AND API.INVOICE_TYPE_LOOKUP_CODE <> 'PREPAYMENT'
      AND ( API.ORG_ID = P_ORG_ID
    OR API.ORG_ID IS NULL );

Line: 375

    SELECT
      NAME
    INTO V_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE NVL(ORGANIZATION_ID
       ,0) = NVL(ORG_ID
       ,0);

Line: 394

      SELECT
        LOCATION_ID
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = ORG_ID;

Line: 400

      SELECT
        ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3
      FROM
        HR_LOCATIONS
      WHERE LOCATION_ID = V_LOCATION_ID;

Line: 419

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 465

      SELECT
        SET_OF_BOOKS_ID
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE NVL(OPERATING_UNIT
         ,0) = NVL(V_ORG_ID
         ,0);

Line: 473

      SELECT
        NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = SOB_ID;

Line: 479

      SELECT
        MULTI_ORG_FLAG
      FROM
        FND_PRODUCT_GROUPS;

Line: 511

      SELECT
        VENDOR_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = V_ID;

Line: 534

      SELECT
        SUM(PREPAY_AMOUNT_REMAINING) * NVL(EXCHANGE_RATE1
           ,1)
      INTO AMOUNT
      FROM
        AP_INVOICE_DISTRIBUTIONS_ALL APD
      GROUP BY
        APD.INVOICE_ID
      HAVING APD.INVOICE_ID = INVOICE_ID1;

Line: 563

      SELECT
        SUM(PREPAY_AMOUNT_REMAINING)
      INTO AMOUNT
      FROM
        AP_INVOICE_DISTRIBUTIONS_ALL APD
      GROUP BY
        APD.INVOICE_ID
      HAVING APD.INVOICE_ID = INVOICE_ID1;