View: JAI_RCV_ACCOUNTING_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_ACCOUNTING_V

View Text

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%'

Columns