[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 |
APPS.PAY_WCI_ACCOUNTS_V