APPS.JA_JAINITCP_XMLP_PKG SQL Statements

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

Line: 5

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

Line: 42

      SELECT
        MIN(API2.INVOICE_DATE)
      INTO P_FROM_DATE_T
      FROM
        JAI_AP_TDS_F16_HDRS_ALL AFRM,
        JAI_AP_TDS_F16_DTLS_ALL FRMD,
        HR_ORGANIZATION_UNITS HOU,
        HR_LOCATIONS LOC,
        JAI_CMN_INVENTORY_ORGS JHOU,
        AP_INVOICES_ALL API1,
        AP_INVOICES_ALL API2,
        AP_INVOICE_PAYMENTS_ALL APIP,
        PO_VENDORS POV1,
        PO_VENDORS POV2,
        PO_VENDORS POV3,
        PO_VENDOR_SITES_ALL POVS,
        AP_INVOICE_LINES_ALL APLA
      WHERE DECODE(AFRM.ORG_ID
            ,NULL
            ,0
            ,AFRM.ORG_ID) = NVL(P_ORGANIZATION_ID
         ,DECODE(AFRM.ORG_ID
               ,NULL
               ,0
               ,AFRM.ORG_ID))
        AND AFRM.TDS_TAX_SECTION = P_TDS_PAYMENT_TYPE
        AND AFRM.ORG_ID = hou.organization_id (+)
        AND FRMD.CERTIFICATE_NUM = AFRM.CERTIFICATE_NUM
        AND apla.invoice_id (+) = FRMD.TDS_INVOICE_ID
        AND ( ( POV1.ORGANIZATION_TYPE_LOOKUP_CODE = P_SUPPLIER_ORG_TYPE_T
        AND UPPER(P_SUPPLIER_ORG_TYPE_T) = 'COMPANY' )
      OR ( POV1.ORGANIZATION_TYPE_LOOKUP_CODE <> P_SUPPLIER_ORG_TYPE_T
        AND UPPER(P_SUPPLIER_ORG_TYPE_T) <> 'COMPANY' ) )
        AND pov1.vendor_id (+) = AFRM.VENDOR_ID
        AND povs.vendor_site_id (+) = AFRM.VENDOR_SITE_ID
        AND POVS.ORG_ID = P_ORGANIZATION_ID
        AND API2.INVOICE_ID = FRMD.TDS_INVOICE_ID
        AND pov3.vendor_id (+) = API2.VENDOR_ID
        AND api1.invoice_id (+) = FRMD.INVOICE_ID
        AND apip.invoice_payment_id (+) = FRMD.INVOICE_PAYMENT_ID
        AND jhou.organization_id (+) = HOU.ORGANIZATION_ID
        AND HOU.LOCATION_ID = loc.location_id (+)
        AND pov2.vendor_id (+) = AFRM.TAX_AUTHORITY_ID;

Line: 93

      SELECT
        SUM(AMOUNT)
      FROM
        AP_INVOICE_LINES_ALL
      WHERE INVOICE_ID = INVOICE_ID_V
        AND LINE_TYPE_LOOKUP_CODE = 'PREPAY';

Line: 113

      SELECT
        NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID;

Line: 119

      SELECT
        NVL(INTERNAL_ADDRESS_LINE
           ,'NIL')
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID;

Line: 126

      SELECT
        NVL(LOC.TOWN_OR_CITY
           ,'NIL') || '-' || NVL(LOC.POSTAL_CODE
           ,'NIL')
      FROM
        HR_LOCATIONS LOC,
        HR_ORGANIZATION_UNITS HR
      WHERE LOC.LOCATION_ID = HR.LOCATION_ID
        AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;

Line: 136

      SELECT
        NVL(LOC.COUNTRY
           ,'NIL')
      FROM
        HR_LOCATIONS LOC,
        HR_ORGANIZATION_UNITS HR
      WHERE LOC.LOCATION_ID = HR.LOCATION_ID
        AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;

Line: 145

      SELECT
        DISTINCT
        ( NVL(PO.VENDOR_NAME
           ,'NULL') )
      FROM
        PO_VENDORS PO,
        JAI_AP_TDS_F16_HDRS_ALL AFRM,
        JAI_AP_TDS_VENDOR_HDRS TDS
      WHERE PO.VENDOR_ID = AFRM.TAX_AUTHORITY_ID
        AND TDS.TAX_ID = AFRM.TDS_TAX_ID
        AND AFRM.TDS_TAX_SECTION = P_TDS_PAYMENT_TYPE;

Line: 157

      SELECT
        NVL(ATTRIBUTE14
           ,'NA')
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = NVL(CP_ORGANIZATION_ID
         ,0);

Line: 165

      SELECT
        NVL(ATTRIBUTE15
           ,'NA')
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = NVL(CP_ORGANIZATION_ID
         ,0);

Line: 212

      SELECT
        POVS.ADDRESS_LINE1 || ',' || POVS.ADDRESS_LINE2 || ',' || POVS.ADDRESS_LINE3 || ',' || POVS.CITY || ',' || POVS.STATE || ',' || POVS.ZIP || ',' || POVS.COUNTRY VENDOR_SITE_ADDRESS
      FROM
        PO_VENDOR_SITES_ALL POVS
      WHERE VENDOR_SITE_ID = VENDOR_SITE_ID_V;

Line: 231

      SELECT
        ACCOUNTING_DATE
      FROM
        AP_INVOICE_LINES_ALL
      WHERE INVOICE_ID = INVOICE_ID_V
        AND LINE_NUMBER = 1;

Line: 255

      SELECT
        SUM(AMOUNT)
      FROM
        AP_INVOICE_DISTRIBUTIONS_ALL APD1
      WHERE INVOICE_ID = INVOICE_ID_V
        AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'
        AND PREPAY_DISTRIBUTION_ID IN (
        SELECT
          INVOICE_DISTRIBUTION_ID
        FROM
          AP_INVOICE_DISTRIBUTIONS_ALL APD2
        WHERE exists (
          SELECT
            1
          FROM
            JAI_AP_TDS_F16_DTLS_ALL JA
          WHERE JA.INVOICE_ID = APD2.INVOICE_ID ) );

Line: 275

      SELECT
        NVL(AMT_REVERSED
           ,0)
      FROM
        JAI_AP_TDS_INVOICES
      WHERE INVOICE_ID = P_INVOICE_ID;

Line: 301

      SELECT
        SUM(AMOUNT)
      FROM
        AP_INVOICE_DISTRIBUTIONS_ALL APD1
      WHERE INVOICE_ID = INVOICE_ID_V
        AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'
        AND PREPAY_DISTRIBUTION_ID IN (
        SELECT
          INVOICE_DISTRIBUTION_ID
        FROM
          AP_INVOICE_DISTRIBUTIONS_ALL APD2
        WHERE exists (
          SELECT
            1
          FROM
            JAI_AP_TDS_F16_DTLS_ALL JA
          WHERE JA.INVOICE_ID = APD2.INVOICE_ID ) );

Line: 321

      SELECT
        NVL(AMT_APPLIED
           ,0)
      FROM
        JAI_AP_TDS_INVOICES
      WHERE INVOICE_ID = P_INVOICE_ID;

Line: 371

      SELECT
        PAN_NO,
        TAN_NO
      FROM
        JAI_AP_TDS_VENDOR_HDRS
      WHERE VENDOR_ID = CP_VENDOR_ID
        AND VENDOR_SITE_ID = CP_VENDOR_SITE_ID;

Line: 409

      SELECT
        ( NVL(TAX_RATE
           ,0) - ( NVL(SURCHARGE_RATE
           ,0) + NVL(CESS_RATE
           ,0) ) ) TDS_RATE,
        NVL(SURCHARGE_RATE
           ,0) SURCHARGE_RATE,
        NVL(CESS_RATE
           ,0),
        NVL(SH_CESS_RATE
           ,0),
        NVL(TAX_RATE
           ,0)
      FROM
        JAI_CMN_TAXES_ALL JTC
      WHERE TAX_ID = P_TAX_ID;