VIEW: APPS.PJI_DEFAULT_PERIOD_SETTINGS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'