DBA Data[Home] [Help]

APPS.JA_JAINST3_XMLP_PKG dependencies on JAI_RGM_MANUAL_TRXS

Line 354: JAI_RGM_MANUAL_TRXS JMT,

350: SELECT
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

Line 595: JAI_RGM_MANUAL_TRXS JMT,

591: SELECT
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

Line 874: JAI_RGM_MANUAL_TRXS JMT,

870: SELECT
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