View: JG_ZZ_AP_IR_REP_ITF_V

Product:	JG - Regional Localizations
Description:	Invoice Register view
Implementation/DBA Data:	APPS.JG_ZZ_AP_IR_REP_ITF_V

View Text

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

Columns