[Home] [Help]
View: PA_XLA_BILL_EVENT_ORG_REF_V
View Text
SELECT HROU.ORGANIZATION_ID
, HROU.NAME
, HROI.ORG_INFORMATION3
, HROI.ORG_INFORMATION5
, HROU.ATTRIBUTE_CATEGORY
, HROU.ATTRIBUTE1
, HROU.ATTRIBUTE2
, HROU.ATTRIBUTE3
, HROU.ATTRIBUTE4
, HROU.ATTRIBUTE5
, HROU.ATTRIBUTE6
, HROU.ATTRIBUTE7
, HROU.ATTRIBUTE8
, HROU.ATTRIBUTE9
, HROU.ATTRIBUTE10
FROM HR_ALL_ORGANIZATION_UNITS HROU
, HR_ORGANIZATION_INFORMATION HROI
WHERE HROI.ORGANIZATION_ID (+) = HROU.ORGANIZATION_ID
AND HROI.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'
Columns
Name |
BILL_EVENT_ORG_ID |
BILL_EVENT_ORGANIZATION |
BILL_EVENT_ORG_COMPANY |
BILL_EVENT_ORG_COST_CENTER |
BILL_EVENT_ORG_ATTR_CATEGORY |
BILL_EVENT_ORG_ATTRIBUTE1 |
BILL_EVENT_ORG_ATTRIBUTE2 |
BILL_EVENT_ORG_ATTRIBUTE3 |
BILL_EVENT_ORG_ATTRIBUTE4 |
BILL_EVENT_ORG_ATTRIBUTE5 |
BILL_EVENT_ORG_ATTRIBUTE6 |
BILL_EVENT_ORG_ATTRIBUTE7 |
BILL_EVENT_ORG_ATTRIBUTE8 |
BILL_EVENT_ORG_ATTRIBUTE9 |
BILL_EVENT_ORG_ATTRIBUTE10 |