DBA Data[Home] [Help]

APPS.JA_JAINSTAC_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 539: AP_INVOICE_DISTRIBUTIONS_ALL APD

535: SUM(PREPAY_AMOUNT_REMAINING) * NVL(EXCHANGE_RATE1
536: ,1)
537: INTO AMOUNT
538: FROM
539: AP_INVOICE_DISTRIBUTIONS_ALL APD
540: GROUP BY
541: APD.INVOICE_ID
542: HAVING APD.INVOICE_ID = INVOICE_ID1;
543: ELSE

Line 567: AP_INVOICE_DISTRIBUTIONS_ALL APD

563: SELECT
564: SUM(PREPAY_AMOUNT_REMAINING)
565: INTO AMOUNT
566: FROM
567: AP_INVOICE_DISTRIBUTIONS_ALL APD
568: GROUP BY
569: APD.INVOICE_ID
570: HAVING APD.INVOICE_ID = INVOICE_ID1;
571: ELSE