eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINST3_XMLP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 79: PO_VENDOR_SITES_ALL VENDSITES,

75: INVC.INVOICE_DATE INVOICE_DATE
76: FROM
77: AP_INVOICE_PAYMENTS_ALL INVCPAY,
78: AP_INVOICES_ALL INVC,
79: PO_VENDOR_SITES_ALL VENDSITES,
80: PO_VENDORS VENDS
81: WHERE INVCPAY.INVOICE_ID = INVC.INVOICE_ID
82: AND INVC.VENDOR_ID = VENDSITES.VENDOR_ID
83: AND VENDSITES.VENDOR_ID = VENDS.VENDOR_ID

Line 323: PO_VENDOR_SITES_ALL PVSA,

319: JAI_RGM_TRX_RECORDS TRXRECS,
320: JAI_RGM_TRX_REFS TRXREFS,
321: AP_INVOICES_ALL APA,
322: JAI_CMN_VENDOR_SITES JPVS,
323: PO_VENDOR_SITES_ALL PVSA,
324: JAI_INV_ITM_SETUPS JMSI
325: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID
326: AND APA.CANCELLED_DATE IS NULL
327: AND APA.CANCELLED_BY IS NULL

Line 355: PO_VENDOR_SITES_ALL PVSA

351: SUM(JRTR.CREDIT_AMOUNT) SERVICE_CREDIT
352: FROM
353: JAI_RGM_TRX_RECORDS JRTR,
354: JAI_RGM_MANUAL_TRXS JMT,
355: PO_VENDOR_SITES_ALL PVSA
356: WHERE JRTR.SOURCE = 'MANUAL'
357: AND JRTR.REGIME_CODE = 'SERVICE'
358: AND JRTR.SOURCE_DOCUMENT_ID = JMT.TRANSACTION_NUMBER
359: AND PVSA.VENDOR_ID = JMT.PARTY_ID

Line 565: PO_VENDOR_SITES_ALL PVSA,

561: JAI_RGM_TRX_RECORDS TRXRECS,
562: JAI_RGM_TRX_REFS TRXREFS,
563: AP_INVOICES_ALL APA,
564: JAI_CMN_VENDOR_SITES JPVS,
565: PO_VENDOR_SITES_ALL PVSA,
566: JAI_INV_ITM_SETUPS JMSI
567: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID
568: AND APA.CANCELLED_DATE IS NULL
569: AND APA.CANCELLED_BY IS NULL

Line 596: PO_VENDOR_SITES_ALL PVSA

592: SUM(JRTR.CREDIT_AMOUNT) SERVICE_CREDIT
593: FROM
594: JAI_RGM_TRX_RECORDS JRTR,
595: JAI_RGM_MANUAL_TRXS JMT,
596: PO_VENDOR_SITES_ALL PVSA
597: WHERE JRTR.SOURCE = 'MANUAL'
598: AND JRTR.REGIME_CODE = 'SERVICE'
599: AND JRTR.SOURCE_DOCUMENT_ID = JMT.TRANSACTION_NUMBER
600: AND PVSA.VENDOR_ID = JMT.PARTY_ID

Line 843: PO_VENDOR_SITES_ALL PVSA,

839: JAI_RGM_TRX_RECORDS TRXRECS,
840: JAI_RGM_TRX_REFS TRXREFS,
841: AP_INVOICES_ALL APA,
842: JAI_CMN_VENDOR_SITES JPVS,
843: PO_VENDOR_SITES_ALL PVSA,
844: JAI_INV_ITM_SETUPS JMSI
845: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID
846: AND APA.CANCELLED_DATE IS NULL
847: AND APA.CANCELLED_BY IS NULL

Line 875: PO_VENDOR_SITES_ALL PVSA

871: SUM(JRTR.CREDIT_AMOUNT) EDU_CESS_CREDIT
872: FROM
873: JAI_RGM_TRX_RECORDS JRTR,
874: JAI_RGM_MANUAL_TRXS JMT,
875: PO_VENDOR_SITES_ALL PVSA
876: WHERE JRTR.SOURCE = 'MANUAL'
877: AND JRTR.REGIME_CODE = 'SERVICE'
878: AND JRTR.SOURCE_DOCUMENT_ID = JMT.TRANSACTION_NUMBER
879: AND PVSA.VENDOR_ID = JMT.PARTY_ID