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

Source

View Text - Preformatted


SELECT organization_code organization_code , transaction_id transaction_id , trunc(transaction_date) transaction_date , trunc(creation_date) creation_date , acct_type acct_type , acct_nature acct_nature , source_name source_name , category_name category_name , code_combination_id code_combination_id , period_name period_name , entered_dr entered_dr , Entered_cr Entered_cr from JAI_RCV_JOURNAL_ENTRIES WHERE upper(acct_nature) not like '%COSTING%' and upper(acct_nature) not like '%DELIVER%'

View Text - HTML Formatted

SELECT ORGANIZATION_CODE ORGANIZATION_CODE
, TRANSACTION_ID TRANSACTION_ID
, TRUNC(TRANSACTION_DATE) TRANSACTION_DATE
, TRUNC(CREATION_DATE) CREATION_DATE
, ACCT_TYPE ACCT_TYPE
, ACCT_NATURE ACCT_NATURE
, SOURCE_NAME SOURCE_NAME
, CATEGORY_NAME CATEGORY_NAME
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, PERIOD_NAME PERIOD_NAME
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
FROM JAI_RCV_JOURNAL_ENTRIES
WHERE UPPER(ACCT_NATURE) NOT LIKE '%COSTING%'
AND UPPER(ACCT_NATURE) NOT LIKE '%DELIVER%'