[Home] [Help]
View: IGS_FI_HIER_ACCT_TBL_V
Product: | IGS - Student System |
Description: | the entities and their respective orders in the account hierarchy defined in the table |
Implementation/DBA Data: |
APPS.IGS_FI_HIER_ACCT_TBL_V
|
View Text
SELECT ACCT.ROWID
, ACCT.ACCT_TBL_ID
, ACCT.ACCT_HIER_ID
, ACCT.ORDER_SEQUENCE
, ACCT.ENTITY_TYPE_CODE
, LKP.MEANING
, ACCT.CREATED_BY
, ACCT.CREATION_DATE
, ACCT.LAST_UPDATED_BY
, ACCT.LAST_UPDATE_DATE
, ACCT.LAST_UPDATE_LOGIN
FROM IGS_FI_HIER_ACCT_TBL ACCT
, IGS_LOOKUPS_VIEW LKP
WHERE ACCT.ENTITY_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'IGS_FI_ACCT_ENTITIES'
Columns
Name |
ROW_ID |
ACCT_TBL_ID |
ACCT_HIER_ID |
ORDER_SEQUENCE |
ENTITY_TYPE_CODE |
ENTITY_TYPE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |