VIEW: APPS.CE_FC_PAIO_DISC_V

Source

View Text - Preformatted

SELECT src.resource_assignment_id||'X'||trunc(src.start_date), src.trx_number, src.revenue, src.raw_cost, src.start_date || ' - ' || src.end_date, src.start_date, src.end_date, src.period_name, src.burdened_cost, pat.task_name, hr.name from pa_ce_integration_budgets_v src, pa_tasks pat, pa_projects_all pap, hr_operating_units hr WHERE src.task_id = pat.task_id and hr.organization_id(+) = pap.org_id and pap.project_id = src.project_id and (pap.org_id is null or exists (select null from ce_security_profiles_v sec where sec.organization_id = pap.org_id and sec.organization_type = 'OPERATING_UNIT'))

View Text - HTML Formatted

SELECT SRC.RESOURCE_ASSIGNMENT_ID||'X'||TRUNC(SRC.START_DATE)
, SRC.TRX_NUMBER
, SRC.REVENUE
, SRC.RAW_COST
, SRC.START_DATE || ' - ' || SRC.END_DATE
, SRC.START_DATE
, SRC.END_DATE
, SRC.PERIOD_NAME
, SRC.BURDENED_COST
, PAT.TASK_NAME
, HR.NAME
FROM PA_CE_INTEGRATION_BUDGETS_V SRC
, PA_TASKS PAT
, PA_PROJECTS_ALL PAP
, HR_OPERATING_UNITS HR
WHERE SRC.TASK_ID = PAT.TASK_ID
AND HR.ORGANIZATION_ID(+) = PAP.ORG_ID
AND PAP.PROJECT_ID = SRC.PROJECT_ID
AND (PAP.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = PAP.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))