[Home] [Help]
View: PA_XCHARGE_PROJECT_TYPES_V
View Text
SELECT PT.PROJECT_TYPE
, PT.DESCRIPTION
, HRORG.ORGANIZATION_ID
, HRORG.NAME
, PT.START_DATE_ACTIVE
, PT.END_DATE_ACTIVE
, PCOU.RECVR_LEGAL_ENTITY_ID
, PCOU.RECVR_BUSINESS_GROUP_ID
, PCOU.RECVR_ORG_ID
, PCOU.PRVDR_LEGAL_ENTITY_ID
, PCOU.BUSINESS_GROUP_ID
, PCOU.PRVDR_ORG_ID
FROM PA_CROSS_CHARGEABLE_OU_V PCOU
, PA_PROJECT_TYPES_ALL PT
, HR_ORGANIZATION_UNITS HRORG
WHERE PCOU.RECVR_ORG_ID = PT.ORG_ID
AND PCOU.RECVR_ORG_ID = HRORG.ORGANIZATION_ID
Columns
Name |
PROJECT_TYPE |
DESCRIPTION |
ORGANIZATION_ID |
NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
RECVR_LEGAL_ENTITY_ID |
RECVR_BUSINESS_GROUP_ID |
RECVR_ORG_ID |
PRVDR_LEGAL_ENTITY_ID |
BUSINESS_GROUP_ID |
PRVDR_ORG_ID |