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.

VIEW: APPS.IGI_AP_INVOICE_LINES_V

Source

View Text - Preformatted


SELECT DISTINCT apl.invoice_id , apl.line_number, apl.line_type_lookup_code, apl.line_source, apl.org_id, apl.default_dist_ccid, apl.accounting_date, apl.set_of_books_id, apl.amount, apl.discarded_flag, igi.last_updated_by , igi.last_updated_date , apl.period_name , apl.base_amount , apl.created_by , apl.creation_date , apl.last_update_login , igi.igi_sap_flag , igi.rowid igi_rowid , apl.rowid lines_rowid FROM AP_INVOICE_LINES_ALL apl, IGI_INVOICE_LINES igi WHERE igi.invoice_id = apl.invoice_id and apl.line_number = igi.line_number

View Text - HTML Formatted

SELECT DISTINCT APL.INVOICE_ID
, APL.LINE_NUMBER
, APL.LINE_TYPE_LOOKUP_CODE
, APL.LINE_SOURCE
, APL.ORG_ID
, APL.DEFAULT_DIST_CCID
, APL.ACCOUNTING_DATE
, APL.SET_OF_BOOKS_ID
, APL.AMOUNT
, APL.DISCARDED_FLAG
, IGI.LAST_UPDATED_BY
, IGI.LAST_UPDATED_DATE
, APL.PERIOD_NAME
, APL.BASE_AMOUNT
, APL.CREATED_BY
, APL.CREATION_DATE
, APL.LAST_UPDATE_LOGIN
, IGI.IGI_SAP_FLAG
, IGI.ROWID IGI_ROWID
, APL.ROWID LINES_ROWID
FROM AP_INVOICE_LINES_ALL APL
, IGI_INVOICE_LINES IGI
WHERE IGI.INVOICE_ID = APL.INVOICE_ID
AND APL.LINE_NUMBER = IGI.LINE_NUMBER