View: PJI_DEFAULT_PERIOD_SETTINGS_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	This is an internal summarization view.
Implementation/DBA Data:	APPS.PJI_DEFAULT_PERIOD_SETTINGS_V

View Text

SELECT L2.MEANING
, SETTING_ID
, DFLT_PRJBAB_PERIOD_TYPE
, DFLT_PRJBAB_AS_OF_DATE
, DFLT_PRJBAB_CYCLE_ID
, B2.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L2
, PA_BILLING_CYCLES B2
, PJI_SYSTEM_SETTINGS PJ2
WHERE PJ2.DFLT_PRJBAB_CYCLE_ID = B2.BILLING_CYCLE_ID (+)
AND L2.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L2.LOOKUP_CODE = 'PROJECT_BOOKINGS_AND_BACKLOG' UNION ALL SELECT L3.MEANING
, SETTING_ID
, DFLT_RESUTL_PERIOD_TYPE
, DFLT_RESUTL_AS_OF_DATE
, DFLT_RESUTL_CYCLE_ID
, B3.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L3
, PA_BILLING_CYCLES B3
, PJI_SYSTEM_SETTINGS PJ3
WHERE PJ3.DFLT_RESUTL_CYCLE_ID = B3.BILLING_CYCLE_ID (+)
AND L3.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L3.LOOKUP_CODE = 'RESOURCE_UTILIZATION' UNION ALL SELECT L4.MEANING
, SETTING_ID
, DFLT_RESAVL_PERIOD_TYPE
, DFLT_RESAVL_AS_OF_DATE
, DFLT_RESAVL_CYCLE_ID
, B4.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L4
, PA_BILLING_CYCLES B4
, PJI_SYSTEM_SETTINGS PJ4
WHERE PJ4.DFLT_RESAVL_CYCLE_ID = B4.BILLING_CYCLE_ID (+)
AND L4.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L4.LOOKUP_CODE = 'RESOURCE_AVAILABILITY' UNION ALL SELECT L4.MEANING
, SETTING_ID
, DFLT_PRJACT_PERIOD_TYPE
, DFLT_PRJACT_AS_OF_DATE
, DFLT_PRJACT_CYCLE_ID
, B4.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L4
, PA_BILLING_CYCLES B4
, PJI_SYSTEM_SETTINGS PJ4
WHERE PJ4.DFLT_PRJACT_CYCLE_ID = B4.BILLING_CYCLE_ID (+)
AND L4.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L4.LOOKUP_CODE = 'PROJECT_ACTIVITY' UNION ALL SELECT L4.MEANING
, SETTING_ID
, DFLT_PRJPRF_PERIOD_TYPE
, DFLT_PRJPRF_AS_OF_DATE
, DFLT_PRJPRF_CYCLE_ID
, B4.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L4
, PA_BILLING_CYCLES B4
, PJI_SYSTEM_SETTINGS PJ4
WHERE PJ4.DFLT_PRJPRF_CYCLE_ID = B4.BILLING_CYCLE_ID (+)
AND L4.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L4.LOOKUP_CODE = 'PROJECT_PROFITABILITY' UNION ALL SELECT L4.MEANING
, SETTING_ID
, DFLT_PRJCST_PERIOD_TYPE
, DFLT_PRJCST_AS_OF_DATE
, DFLT_PRJCST_CYCLE_ID
, B4.BILLING_CYCLE_NAME
FROM PJI_LOOKUPS L4
, PA_BILLING_CYCLES B4
, PJI_SYSTEM_SETTINGS PJ4
WHERE PJ4.DFLT_PRJCST_CYCLE_ID = B4.BILLING_CYCLE_ID (+)
AND L4.LOOKUP_TYPE = 'PJI_REPORT_GROUP'
AND L4.LOOKUP_CODE = 'PROJECT_COST'

Columns