VIEW: APPS.PA_COST_DIST_OVERRIDES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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