[Home] [Help]
View: PSP_AUTO_ACCTS_V
View Text
SELECT A.ROWID ROW_ID
, A.ACCT_ID
, A.ACCT_SEQ_NUM
, A.ACCT_TYPE
, A.PERIOD_TYPE
, A.EXPENDITURE_TYPE
, A.SEGMENT_NUM
, A.NATURAL_ACCOUNT
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, B.RULE_DEFINITION
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSP_AUTO_ACCTS A
, PSP_AUTO_RULES B
WHERE A.ACCT_ID = B.ACCT_ID(+)
Columns
Name |
ROW_ID |
ACCT_ID |
ACCT_SEQ_NUM |
ACCT_TYPE |
PERIOD_TYPE |
EXPENDITURE_TYPE |
SEGMENT_NUM |
NATURAL_ACCOUNT |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |
RULE_DEFINITION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |