VIEW: APPS.JG_ZZ_AP_IR_REP_ITF_V

Source

View Text - Preformatted

SELECT IRT.ROWID, IRT.REQUEST_ID, IRT.CREATED_BY, IRT.CREATION_DATE, IRT.LAST_UPDATE_DATE, IRT.LAST_UPDATED_BY, IRT.LAST_UPDATE_LOGIN, IRT.FUNCTIONAL_CURRENCY_CODE, IRT.ORGANIZATION_NAME, IRT.INVOICE_ID, INV.BATCH_ID, BAT.BATCH_NAME, INV.VENDOR_ID, PV.VENDOR_NAME, PV.VENDOR_NAME_ALT, PV.SEGMENT1, PVS.VENDOR_SITE_CODE, INV.INVOICE_NUM, INV.INVOICE_CURRENCY_CODE, FDS.NAME, INV.DOC_SEQUENCE_VALUE, INV.INVOICE_DATE, INV.INVOICE_AMOUNT, nvl(INV.INVOICE_AMOUNT,0)- nvl(INV.AMOUNT_PAID,0) - nvl(INV.DISCOUNT_AMOUNT_TAKEN,0), INV.DESCRIPTION, ALC1.DISPLAYED_FIELD, PMS.PAYMENT_METHOD_NAME, IRT.LIABILITY_CCID, IRT.LIABILITY_ACCOUNT, IRT.LIABILITY_DESC, IRT.LIABILITY_NATACC, IRT.LIABILITY_NATACC_DESC, IRT.LINE_NUMBER, ALC5.DISPLAYED_FIELD, LINE.DESCRIPTION, LINE.AMOUNT, IRT.INVOICE_DISTRIBUTION_ID, ALC3.DISPLAYED_FIELD, DIST.DISTRIBUTION_LINE_NUMBER, DIST.AMOUNT, DIST.DESCRIPTION, nvl(IRT.ACCOUNTING_DATE,DIST.ACCOUNTING_DATE), DIST.TYPE_1099, TAX_LINE.TAX, TAX_LINE.TAX_RATE, ALC4.DISPLAYED_FIELD, IRT.DISTRIBUTION_CCID, IRT.DISTRIBUTION_ACCOUNT, IRT.DISTRIBUTION_ACCOUNT_DESC, IRT.DISTRIBUTION_NATACC, IRT.DISTRIBUTION_NATACC_DESC From JG_ZZ_AP_IR_REP_ITF IRT, AP_INVOICES_ALL INV, AP_INVOICE_LINES_ALL LINE, AP_INVOICE_DISTRIBUTIONS_ALL DIST, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, FND_DOCUMENT_SEQUENCES FDS, AP_LOOKUP_CODES ALC1, IBY_PAYMENT_METHODS_VL PMS, AP_LOOKUP_CODES ALC3, AP_LOOKUP_CODES ALC4, AP_LOOKUP_CODES ALC5, AP_TAX_CODES_ALL ATC, AP_BATCHES_ALL BAT, ZX_LINES TAX_LINE WHERE IRT.INVOICE_ID = INV.INVOICE_ID and INV.BATCH_ID = BAT.BATCH_ID (+) AND IRT.INVOICE_ID = LINE.INVOICE_ID (+) AND IRT.LINE_NUMBER = LINE.LINE_NUMBER (+) and IRT.INVOICE_DISTRIBUTION_ID = DIST.INVOICE_DISTRIBUTION_ID (+) and INV.VENDOR_ID = PV.VENDOR_ID and INV.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID and FDS.DOC_SEQUENCE_ID (+)= INV.DOC_SEQUENCE_ID and ATC.TAX_ID (+) = DIST.TAX_CODE_ID and ALC1.LOOKUP_CODE =IRT.INVOICE_TYPE and ALC1.LOOKUP_TYPE ='INVOICE TYPE' and PMS.PAYMENT_METHOD_CODE =INV.PAYMENT_METHOD_CODE and ALC3.LOOKUP_CODE(+) = IRT.DIST_TYPE and ALC3.LOOKUP_TYPE(+) =nvl('INVOICE DISTRIBUTION TYPE',null) and ALC4.LOOKUP_CODE(+) = DIST.POSTED_FLAG and ALC4.LOOKUP_TYPE(+) =nvl('POSTING STATUS',null) AND ALC5.LOOKUP_CODE(+) = IRT.LINE_TYPE AND ALC5.LOOKUP_TYPE(+) = NVL('INVOICE LINE TYPE',NULL) AND TAX_LINE.TRX_LINE_ID(+) = IRT.LINE_NUMBER AND TAX_LINE.TRX_ID(+) = IRT.INVOICE_ID

View Text - HTML Formatted

SELECT IRT.ROWID
, IRT.REQUEST_ID
, IRT.CREATED_BY
, IRT.CREATION_DATE
, IRT.LAST_UPDATE_DATE
, IRT.LAST_UPDATED_BY
, IRT.LAST_UPDATE_LOGIN
, IRT.FUNCTIONAL_CURRENCY_CODE
, IRT.ORGANIZATION_NAME
, IRT.INVOICE_ID
, INV.BATCH_ID
, BAT.BATCH_NAME
, INV.VENDOR_ID
, PV.VENDOR_NAME
, PV.VENDOR_NAME_ALT
, PV.SEGMENT1
, PVS.VENDOR_SITE_CODE
, INV.INVOICE_NUM
, INV.INVOICE_CURRENCY_CODE
, FDS.NAME
, INV.DOC_SEQUENCE_VALUE
, INV.INVOICE_DATE
, INV.INVOICE_AMOUNT
, NVL(INV.INVOICE_AMOUNT
, 0)- NVL(INV.AMOUNT_PAID
, 0) - NVL(INV.DISCOUNT_AMOUNT_TAKEN
, 0)
, INV.DESCRIPTION
, ALC1.DISPLAYED_FIELD
, PMS.PAYMENT_METHOD_NAME
, IRT.LIABILITY_CCID
, IRT.LIABILITY_ACCOUNT
, IRT.LIABILITY_DESC
, IRT.LIABILITY_NATACC
, IRT.LIABILITY_NATACC_DESC
, IRT.LINE_NUMBER
, ALC5.DISPLAYED_FIELD
, LINE.DESCRIPTION
, LINE.AMOUNT
, IRT.INVOICE_DISTRIBUTION_ID
, ALC3.DISPLAYED_FIELD
, DIST.DISTRIBUTION_LINE_NUMBER
, DIST.AMOUNT
, DIST.DESCRIPTION
, NVL(IRT.ACCOUNTING_DATE
, DIST.ACCOUNTING_DATE)
, DIST.TYPE_1099
, TAX_LINE.TAX
, TAX_LINE.TAX_RATE
, ALC4.DISPLAYED_FIELD
, IRT.DISTRIBUTION_CCID
, IRT.DISTRIBUTION_ACCOUNT
, IRT.DISTRIBUTION_ACCOUNT_DESC
, IRT.DISTRIBUTION_NATACC
, IRT.DISTRIBUTION_NATACC_DESC
FROM JG_ZZ_AP_IR_REP_ITF IRT
, AP_INVOICES_ALL INV
, AP_INVOICE_LINES_ALL LINE
, AP_INVOICE_DISTRIBUTIONS_ALL DIST
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, FND_DOCUMENT_SEQUENCES FDS
, AP_LOOKUP_CODES ALC1
, IBY_PAYMENT_METHODS_VL PMS
, AP_LOOKUP_CODES ALC3
, AP_LOOKUP_CODES ALC4
, AP_LOOKUP_CODES ALC5
, AP_TAX_CODES_ALL ATC
, AP_BATCHES_ALL BAT
, ZX_LINES TAX_LINE
WHERE IRT.INVOICE_ID = INV.INVOICE_ID
AND INV.BATCH_ID = BAT.BATCH_ID (+)
AND IRT.INVOICE_ID = LINE.INVOICE_ID (+)
AND IRT.LINE_NUMBER = LINE.LINE_NUMBER (+)
AND IRT.INVOICE_DISTRIBUTION_ID = DIST.INVOICE_DISTRIBUTION_ID (+)
AND INV.VENDOR_ID = PV.VENDOR_ID
AND INV.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND FDS.DOC_SEQUENCE_ID (+)= INV.DOC_SEQUENCE_ID
AND ATC.TAX_ID (+) = DIST.TAX_CODE_ID
AND ALC1.LOOKUP_CODE =IRT.INVOICE_TYPE
AND ALC1.LOOKUP_TYPE ='INVOICE TYPE'
AND PMS.PAYMENT_METHOD_CODE =INV.PAYMENT_METHOD_CODE
AND ALC3.LOOKUP_CODE(+) = IRT.DIST_TYPE
AND ALC3.LOOKUP_TYPE(+) =NVL('INVOICE DISTRIBUTION TYPE'
, NULL)
AND ALC4.LOOKUP_CODE(+) = DIST.POSTED_FLAG
AND ALC4.LOOKUP_TYPE(+) =NVL('POSTING STATUS'
, NULL)
AND ALC5.LOOKUP_CODE(+) = IRT.LINE_TYPE
AND ALC5.LOOKUP_TYPE(+) = NVL('INVOICE LINE TYPE'
, NULL)
AND TAX_LINE.TRX_LINE_ID(+) = IRT.LINE_NUMBER
AND TAX_LINE.TRX_ID(+) = IRT.INVOICE_ID