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
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
|
|
|