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.AP_APPLICABLE_LINES_V

Source

View Text - Preformatted


SELECT ail.rowid row_id, ail.invoice_id, ail.line_number to_invoice_line_number, ail.line_type_lookup_code, alc.displayed_field line_type, ail.description, ail.amount line_amount FROM ap_invoice_lines ail, ap_lookup_codes alc WHERE alc.lookup_type = 'INVOICE LINE TYPE' AND ail.line_type_lookup_code = alc.lookup_code

View Text - HTML Formatted

SELECT AIL.ROWID ROW_ID
, AIL.INVOICE_ID
, AIL.LINE_NUMBER TO_INVOICE_LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD LINE_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT LINE_AMOUNT
FROM AP_INVOICE_LINES AIL
, AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE