PJF_PROJECTS_BASIC

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
PROJECT_ID SEGMENT1 NAME DESCRIPTION PROJECT_TYPE_ID CARRYING_OUT_ORGANIZATION_ID PROJECT_STATUS_CODE PROJECT_UNIT_ID TEMPLATE_FLAG BILLABLE_FLAG CAPITALIZATION_FLAG PM_PROJECT_REFERENCE ORG_ID START_DATE COMPLETION_DATE PROJECT_CURRENCY_CODE ALLOW_CROSS_CHARGE_FLAG PRIMARY_LEDGER_ID PROJFUNC_CURRENCY_CODE PROJECT_CATEGORY PROJECT_CALENDAR_ID HOURS_PER_DAY EXTERNAL_PROJECT_ID BU_NAME PU_NAME

Name

PROJECT_ID

SEGMENT1

NAME

DESCRIPTION

PROJECT_TYPE_ID

CARRYING_OUT_ORGANIZATION_ID

PROJECT_STATUS_CODE

PROJECT_UNIT_ID

TEMPLATE_FLAG

BILLABLE_FLAG

CAPITALIZATION_FLAG

PM_PROJECT_REFERENCE

ORG_ID

START_DATE

COMPLETION_DATE

PROJECT_CURRENCY_CODE

ALLOW_CROSS_CHARGE_FLAG

PRIMARY_LEDGER_ID

PROJFUNC_CURRENCY_CODE

PROJECT_CATEGORY

PROJECT_CALENDAR_ID

HOURS_PER_DAY

EXTERNAL_PROJECT_ID

BU_NAME

PU_NAME

Query

SQL_Statement
SELECT P.project_id, P.segment1, P.name, P.description, P.project_type_id, P.carrying_out_organization_id, P.project_status_code, P.project_unit_id, NVL(P.template_flag, 'N') "TEMPLATE_FLAG", PRJTY.ENABLE_BILLING_FLAG "BILLABLE_FLAG", PRJTY.ENABLE_CAPITALIZATION_FLAG "CAPITALIZATION_FLAG", P.pm_project_reference, P.org_id, P.start_date, P.completion_date, P.project_currency_code, P.allow_cross_charge_flag, ledger.ORG_INFORMATION3 PRIMARY_LEDGER_ID, P.projfunc_currency_code, P.project_category, P.project_calendar_id, P.hours_per_day, P.external_project_id , BU.name BU_NAME, PU.name PU_NAME FROM PJF_PROJECTS_ALL_VL P, PJF_PROJECT_TYPES_B PRJTY, HR_ORGANIZATION_UNITS_F_TL BU, HR_ORGANIZATION_UNITS_F_TL PU, HR_ORGANIZATION_INFORMATION_X ledger WHERE NVL(P.template_flag, 'N') <> 'Y' AND bu.organization_id = P.org_id and bu.LANGUAGE = USERENV('LANG') and trunc(sysdate) between BU.EFFECTIVE_START_DATE and BU.EFFECTIVE_END_DATE AND PU.organization_id = P.PROJECT_UNIT_ID and PU.LANGUAGE = USERENV('LANG') and trunc(sysdate) between PU.EFFECTIVE_START_DATE and PU.EFFECTIVE_END_DATE AND P.PROJECT_TYPE_ID = PRJTY.PROJECT_TYPE_ID AND ledger.ORGANIZATION_ID = P.org_id AND ledger.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'

SQL_Statement

SELECT

P.project_id,

P.segment1,

P.name,

P.description,

P.project_type_id,

P.carrying_out_organization_id,

P.project_status_code,

P.project_unit_id,

NVL(P.template_flag, 'N') "TEMPLATE_FLAG",

PRJTY.ENABLE_BILLING_FLAG "BILLABLE_FLAG",

PRJTY.ENABLE_CAPITALIZATION_FLAG "CAPITALIZATION_FLAG",

P.pm_project_reference,

P.org_id,

P.start_date,

P.completion_date,

P.project_currency_code,

P.allow_cross_charge_flag,

ledger.ORG_INFORMATION3 PRIMARY_LEDGER_ID,

P.projfunc_currency_code,

P.project_category,

P.project_calendar_id,

P.hours_per_day,

P.external_project_id ,

BU.name BU_NAME,

PU.name PU_NAME

FROM PJF_PROJECTS_ALL_VL P,

PJF_PROJECT_TYPES_B PRJTY,

HR_ORGANIZATION_UNITS_F_TL BU,

HR_ORGANIZATION_UNITS_F_TL PU,

HR_ORGANIZATION_INFORMATION_X ledger

WHERE NVL(P.template_flag, 'N') <> 'Y'

AND bu.organization_id = P.org_id

and bu.LANGUAGE = USERENV('LANG')

and trunc(sysdate) between BU.EFFECTIVE_START_DATE and BU.EFFECTIVE_END_DATE

AND PU.organization_id = P.PROJECT_UNIT_ID

and PU.LANGUAGE = USERENV('LANG')

and trunc(sysdate) between PU.EFFECTIVE_START_DATE and PU.EFFECTIVE_END_DATE

AND P.PROJECT_TYPE_ID = PRJTY.PROJECT_TYPE_ID

AND ledger.ORGANIZATION_ID = P.org_id

AND ledger.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'