[Home] [Help]
View: IGS_FI_P_CUST_ACCT_V
Product: | IGS - Student System (Obsolete) |
Description: | No longer used. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FC.ROWID
, FC.PARTY_ID
, FC.CUST_ACCOUNT_ID
, CA.ACCOUNT_NUMBER
, FC.CUST_ACCT_SITE_ID
, FC.SITE_USE_ID
, FC.CREATED_BY
, FC.CREATION_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATE_LOGIN
FROM IGS_FI_P_CUST_ACCT FC
, HZ_CUST_ACCOUNTS CA
WHERE FC.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
Columns
Name |
ROW_ID |
PARTY_ID |
CUST_ACCOUNT_ID |
ACCOUNT_NUMBER |
CUST_ACCT_SITE_ID |
SITE_USE_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |