[Home] [Help]
View: PAY_WCI_ACCOUNTS_V
View Text
SELECT DISTINCT PWA.ACCOUNT_ID
, PWA.BUSINESS_GROUP_ID
, PWA.CARRIER_ID
, HOU.NAME CARRIER_NAME
, HOI.ORG_INFORMATION1 PROVINCE
, PWA.LOCATION_ID
, PWA.NAME
, PWA.ACCOUNT_NUMBER
, PWA.LAST_UPDATED_BY
, PWA.LAST_UPDATE_LOGIN
, PWA.LAST_UPDATE_DATE
, PWA.CREATED_BY
, PWA.CREATION_DATE
, PWA.OBJECT_VERSION_NUMBER
FROM HR_ORGANIZATION_INFORMATION HOI
, HR_ORGANIZATION_UNITS HOU
, PAY_WCI_ACCOUNTS PWA
WHERE PWA.CARRIER_ID = HOU.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'WORKERS COMP INFO.'
Columns
Name |
ACCOUNT_ID |
BUSINESS_GROUP_ID |
CARRIER_ID |
CARRIER_NAME |
PROVINCE |
LOCATION_ID |
NAME |
ACCOUNT_NUMBER |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |
OBJECT_VERSION_NUMBER |