VIEW: APPS.PSP_AUTO_ACCTS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)