VIEW: APPS.IGI_MPP_EXP_RECOGNITION

Source

View Text - Preformatted

SELECT aiv.INVOICE_CURRENCY_CODE , mpp_dist.distribution_line_number , aiv.VENDOR_NAME , aiv.VENDOR_SITE_CODE , aiv.INVOICE_TYPE_LOOKUP_CODE , aidv.ACCOUNTING_DATE , nvl(mpp_dist.entered_dr,0) + nvl(mpp_dist.entered_cr,0) amount , nvl(mpp_dist.entered_dr,0) entered_dr , nvl(mpp_dist.entered_cr,0) entered_cr , nvl(mpp_dist.accounted_dr,0) accounted_dr , nvl(mpp_dist.accounted_cr,0) accounted_cr , mpp_dist.CODE_COMBINATION_ID , mpp_dist.PERIOD_NAME , nvl(aiv.batch_id,-1) batch_id , aiv.invoice_id , aiv.set_of_books_id , gsob.chart_of_accounts_id , aiv.INVOICE_NUM , gps.effective_period_num , gps.start_date , gps.end_date , mpp_dist.reference1 mpp_dist_line_number , mpp_dist.expense_recognized_flag , mpp_dist.subledger_entry_id from ap_invoice_distributions_v aidv , ap_invoices_v aiv , gl_period_statuses gps , gl_sets_of_books gsob , igi_mpp_subledger mpp_dist WHERE aiv.invoice_id = aidv.invoice_id and aidv.invoice_id = mpp_dist.invoice_id and aiv.set_of_books_id = gsob.set_of_books_id and aidv.distribution_line_number = mpp_dist.distribution_line_number and gps.set_of_books_id = aidv.set_of_books_id and gps.application_id = 200 and gps.PERIOD_NAME = mpp_dist.PERIOD_NAME order by gps.period_num, gps.period_year, aiv.vendor_name, aiv.invoice_num ,mpp_dist.reference1

View Text - HTML Formatted

SELECT AIV.INVOICE_CURRENCY_CODE
, MPP_DIST.DISTRIBUTION_LINE_NUMBER
, AIV.VENDOR_NAME
, AIV.VENDOR_SITE_CODE
, AIV.INVOICE_TYPE_LOOKUP_CODE
, AIDV.ACCOUNTING_DATE
, NVL(MPP_DIST.ENTERED_DR
, 0) + NVL(MPP_DIST.ENTERED_CR
, 0) AMOUNT
, NVL(MPP_DIST.ENTERED_DR
, 0) ENTERED_DR
, NVL(MPP_DIST.ENTERED_CR
, 0) ENTERED_CR
, NVL(MPP_DIST.ACCOUNTED_DR
, 0) ACCOUNTED_DR
, NVL(MPP_DIST.ACCOUNTED_CR
, 0) ACCOUNTED_CR
, MPP_DIST.CODE_COMBINATION_ID
, MPP_DIST.PERIOD_NAME
, NVL(AIV.BATCH_ID
, -1) BATCH_ID
, AIV.INVOICE_ID
, AIV.SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID
, AIV.INVOICE_NUM
, GPS.EFFECTIVE_PERIOD_NUM
, GPS.START_DATE
, GPS.END_DATE
, MPP_DIST.REFERENCE1 MPP_DIST_LINE_NUMBER
, MPP_DIST.EXPENSE_RECOGNIZED_FLAG
, MPP_DIST.SUBLEDGER_ENTRY_ID
FROM AP_INVOICE_DISTRIBUTIONS_V AIDV
, AP_INVOICES_V AIV
, GL_PERIOD_STATUSES GPS
, GL_SETS_OF_BOOKS GSOB
, IGI_MPP_SUBLEDGER MPP_DIST
WHERE AIV.INVOICE_ID = AIDV.INVOICE_ID
AND AIDV.INVOICE_ID = MPP_DIST.INVOICE_ID
AND AIV.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND AIDV.DISTRIBUTION_LINE_NUMBER = MPP_DIST.DISTRIBUTION_LINE_NUMBER
AND GPS.SET_OF_BOOKS_ID = AIDV.SET_OF_BOOKS_ID
AND GPS.APPLICATION_ID = 200
AND GPS.PERIOD_NAME = MPP_DIST.PERIOD_NAME ORDER BY GPS.PERIOD_NUM
, GPS.PERIOD_YEAR
, AIV.VENDOR_NAME
, AIV.INVOICE_NUM
, MPP_DIST.REFERENCE1