Product: | PA - Projects |
---|---|
Description: | 10Sc Only |
Implementation/DBA Data: | APPS.PA_COST_DIST_OVERRIDES_V |
SELECT DISTINCT CO.ROWID
, CO.COST_DISTRIBUTION_OVERRIDE_ID
, CO.PROJECT_ID
, CO.OVERRIDE_TO_ORGANIZATION_ID
, CO.START_DATE_ACTIVE
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_LOGIN
, CO.PERSON_ID
, CO.EXPENDITURE_CATEGORY
, CO.OVERRIDE_FROM_ORGANIZATION_ID
, CO.END_DATE_ACTIVE
, E.FULL_NAME
, E.EMPLOYEE_NUMBER
, O1.NAME
, NULL
FROM PA_COST_DIST_OVERRIDES CO
, PA_EMPLOYEES E
, PA_ORGANIZATIONS_EXP_ALL_BG_V O1
WHERE CO.PERSON_ID = E.PERSON_ID
AND CO.OVERRIDE_TO_ORGANIZATION_ID = O1.ORGANIZATION_ID
AND CO.OVERRIDE_FROM_ORGANIZATION_ID IS NULL UNION ALL SELECT DISTINCT CO.ROWID
, CO.COST_DISTRIBUTION_OVERRIDE_ID
, CO.PROJECT_ID
, CO.OVERRIDE_TO_ORGANIZATION_ID
, CO.START_DATE_ACTIVE
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_LOGIN
, CO.PERSON_ID
, CO.EXPENDITURE_CATEGORY
, CO.OVERRIDE_FROM_ORGANIZATION_ID
, CO.END_DATE_ACTIVE
, NULL
, NULL
, O1.NAME
, O2.NAME
FROM PA_COST_DIST_OVERRIDES CO
, PA_ORGANIZATIONS_EXP_ALL_BG_V O1
, PA_ORGANIZATIONS_EXP_ALL_BG_V O2
WHERE CO.PERSON_ID IS NULL
AND CO.OVERRIDE_TO_ORGANIZATION_ID = O1.ORGANIZATION_ID
AND CO.OVERRIDE_FROM_ORGANIZATION_ID = O2.ORGANIZATION_ID