[Home] [Help]
View: JAI_RCV_COSTING_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) LIKE '%COSTING%' OR UPPER(ACCT_NATURE) LIKE '%DELIVER%')
Columns
Name |
ORGANIZATION_CODE |
TRANSACTION_ID |
TRANSACTION_DATE |
CREATION_DATE |
ACCT_TYPE |
ACCT_NATURE |
SOURCE_NAME |
CATEGORY_NAME |
CODE_COMBINATION_ID |
PERIOD_NAME |
ENTERED_DR |
ENTERED_CR |