eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_OLAP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23


  '  SELECT PROJECT_ID,    PROJECT_ORG_ID,    PROJECT_ORGANIZATION_ID,    PROJECT_ELEMENT_ID,    TIME_ID ,
     PERIOD_TYPE_ID,    CALENDAR_TYPE,    RBS_AGGR_LEVEL,    WBS_ROLLUP_FLAG,    PRG_ROLLUP_FLAG,    CURR_RECORD_TYPE_ID,
    CURRENCY_CODE,    RBS_ELEMENT_ID,    RBS_VERSION_ID,    PLAN_VERSION_ID,    PLAN_TYPE_ID,
	-1 cbs_element_id ,
    -1 cbs_version_id ,
    LAST_UPDATE_DATE,    LAST_UPDATED_BY,    CREATION_DATE,    CREATED_BY,    LAST_UPDATE_LOGIN  ,
      RAW_COST,    BRDN_COST,    REVENUE,    BILL_RAW_COST,    BILL_BRDN_COST,    BILL_LABOR_RAW_COST,    BILL_LABOR_BRDN_COST,
    BILL_LABOR_HRS,    EQUIPMENT_RAW_COST,    EQUIPMENT_BRDN_COST,    CAPITALIZABLE_RAW_COST,    CAPITALIZABLE_BRDN_COST,
    LABOR_RAW_COST,    LABOR_BRDN_COST,    LABOR_HRS,    LABOR_REVENUE,    EQUIPMENT_HOURS,    BILLABLE_EQUIPMENT_HOURS,
    NVL(SUP_INV_COMMITTED_COST,0) SUP_INV_COMMITTED_COST,    NVL(PO_COMMITTED_COST,0) PO_COMMITTED_COST,
    NVL(PR_COMMITTED_COST,0) PR_COMMITTED_COST,    NVL(OTH_COMMITTED_COST,0) OTH_COMMITTED_COST,
    PLAN_TYPE_CODE,
    CUSTOM1,    CUSTOM2,    CUSTOM3,    CUSTOM4,    CUSTOM5,    CUSTOM6,    CUSTOM7,    CUSTOM8,    CUSTOM9,    CUSTOM10,
    CUSTOM11,    CUSTOM12,    CUSTOM13,    CUSTOM14,    CUSTOM15,    CAST(NULL AS NUMBER) CUSTOM16,    CAST(NULL AS NUMBER) CUSTOM17,
    CAST(NULL AS NUMBER) CUSTOM18,    CAST(NULL AS NUMBER) CUSTOM19,    CAST(NULL AS NUMBER) CUSTOM20,    CAST(NULL AS NUMBER) CUSTOM21,
    CAST(NULL AS NUMBER) CUSTOM22,    CAST(NULL AS NUMBER) CUSTOM23,    CAST(NULL AS NUMBER) CUSTOM24,    CAST(NULL AS NUMBER) CUSTOM25,
    CAST(NULL AS NUMBER) CUSTOM26,    CAST(NULL AS NUMBER) CUSTOM27,    CAST(NULL AS NUMBER) CUSTOM28,    CAST(NULL AS NUMBER) CUSTOM29,
    CAST(NULL AS NUMBER) CUSTOM30
  FROM  	   PJI_FP_XBS_ACCUM_F
  where PA_olap_PVT.G_pjt_rollup_flag  = ''N''
  UNION ALL
  select /*+ ordered */
      to_number(fct.PA_PROJECT_DIM) project_id , p.org_id ,  p.carrying_out_organization_id,
	  to_number(fct.PA_TASK_DM) project_element_id , to_number(fct.PA_TIME_DM) time_id ,
 -1 period_type_id , fct.PA_CALENDAR_TYPE calendar_type,''T''    rbs_aggr_level ,
 ''Y''    wbs_rollup_flag ,''N''    prg_ROLLUP_FLAG , -1 curr_record_type_id  ,
 fct.PA_CURRENCY_DM currency_code , to_number(fct.PA_RBS_ELEMENTS_DM) rbs_element_id ,
 to_number(fct.PA_RBS_VERSIONS_DM) rbs_version_id , to_number(fct.PA_PLAN_VERSIONS_DM) plan_version_id ,
 nvl(b.fin_plan_type_id,-1)  plan_type_id , to_number(fct.PA_CBS_ELEMENTS_DM) cbs_element_id ,
 to_number(fct.PA_CBS_VERSIONS_DM) cbs_version_id ,
  sysdate LAST_UPDATE_DATE , -1 LAST_UPDATED_BY,
  sysdate CREATION_DATE, -1 CREATED_BY, -1   LAST_UPDATE_LOGIN,
  fct.RAW_COST , fct.BRDN_COST , fct.REVENUE ,
  fct.BILL_RAW_COST, fct.BILL_BRDN_COST , fct.BILL_LABOR_RAW_COST , fct.BILL_LABOR_BRDN_COST ,
 fct.BILL_LABOR_HRS , fct.EQUIPMENT_RAW_COST , fct.EQUIPMENT_BRDN_COST , fct.CAPITALIZABLE_RAW_COST ,
 fct.CAPITALIZABLE_BRDN_COST , fct.LABOR_RAW_COST , fct.LABOR_BRDN_COST , fct.LABOR_HRS ,
 fct.LABOR_REVENUE, fct.EQUIPMENT_HOURS , fct.BILLABLE_EQUIPMENT_HOURS , fct.SUP_INV_COMMITTED_COST ,
 fct.PO_COMMITTED_COST , fct.PR_COMMITTED_COST , fct.OTH_COMMITTED_COST ,
    DECODE (b.version_type, ''COST'' ,''C'' , ''REVENUE'', ''R'', ''A'') plan_type_code,
    fct.CUSTOM1 , fct.CUSTOM2 ,
 fct.CUSTOM3 , fct.CUSTOM4 , fct.CUSTOM5 , fct.CUSTOM6 , fct.CUSTOM7 , fct.CUSTOM8 , fct.CUSTOM9 , fct.CUSTOM10 , fct.CUSTOM11 ,
 fct.CUSTOM12 , fct.CUSTOM13 , fct.CUSTOM14 , fct.CUSTOM15 ,
   to_number(null) CUSTOM16 ,  to_number(null) CUSTOM17,  to_number(null) CUSTOM18,
   to_number(null) CUSTOM19 ,  to_number(null) CUSTOM20,  to_number(null) CUSTOM21,
 to_number(null) CUSTOM22 ,  to_number(null) CUSTOM23,  to_number(null) CUSTOM24,
   to_number(null) CUSTOM25,  to_number(null) CUSTOM26,  to_number(null) CUSTOM27,
    to_number(null) CUSTOM28,  to_number(null) CUSTOM29,  to_number(null) CUSTOM30
from PA_PLAN_ACTUALS_CUBE_VIEW  fct ,
      pa_budget_versions  b ,
	  pa_projects_all p
	  where b.budget_version_id (+) = fct.PA_PLAN_VERSIONS_DM
	  and  p.project_id = fct.PA_PROJECT_DIM
	  AND  PA_olap_PVT.G_pjt_rollup_flag = ''Y'''  ;

Line: 80


  nev_text := 'SELECT
  to_number(PA_PROJECT_DIM) PROJECT_ID,  to_number(p.org_id) PROJECT_ORG_ID,
  to_number(p.carrying_out_organization_id) PROJECT_ORGANIZATION_ID,
  to_number(PA_TASK_DM) PROJECT_ELEMENT_ID,  to_number(PA_TIME_DM) TIME_ID,  -1 PERIOD_TYPE_ID, PA_CALENDAR_TYPE  CALENDAR_TYPE, ''Y''  WBS_ROLLUP_FLAG,  ''N'' PRG_ROLLUP_FLAG,
  -1 CURR_RECORD_TYPE_ID,  PA_CURRENCY_DM CURRENCY_CODE,  REVENUE,  INITIAL_FUNDING_AMOUNT,  INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_AMOUN ADDITIONAL_FUNDING_AMOUNT,  ADDITIONAL_FUNDING_COUNT,
  CANCELLED_FUNDING_AMOUNT,  CANCELLED_FUNDING_COUNT,  FUNDING_ADJUSTMENT_AMOUN FUNDING_ADJUSTMENT_AMOUNT,  FUNDING_ADJUSTMENT_COUNT,  REVENUE_WRITEOFF,  AR_INVOICE_AMOUNT,  AR_INVOICE_COUNT,
  AR_CASH_APPLIED_AMOUNT,  AR_INVOICE_WRITE_OFF_AMO AR_INVOICE_WRITE_OFF_AMOUNT, AR_INVOICE_WRITEOFF_COUN AR_INVOICE_WRITEOFF_COUNT,  AR_CREDIT_MEMO_AMOUNT,  AR_CREDIT_MEMO_COUNT,  UNBILLED_RECEIVABLES,
  UNEARNED_REVENUE,  AR_UNAPPR_INVOICE_AMOUNT,  AR_UNAPPR_INVOICE_COUNT,  AR_APPR_INVOICE_AMOUNT,  AR_APPR_INVOICE_COUNT,  AR_AMOUNT_DUE,  AR_COUNT_DUE,  AR_AMOUNT_OVERDUE,
  AR_COUNT_OVERDUE,  DORMANT_BACKLOG_INACTIV,  DORMANT_BACKLOG_START,  LOST_BACKLOG,  ACTIVE_BACKLOG,  REVENUE_AT_RISK,  LAST_UPDATE_DATE,  LAST_UPDATED_BY,  CREATION_DATE,
  CREATED_BY,  LAST_UPDATE_LOGIN,  CUSTOM1,  CUSTOM2,  CUSTOM3,  CUSTOM4,  CUSTOM5,  CUSTOM6,  CUSTOM7,  CUSTOM8,  CUSTOM9,  CUSTOM10,  CUSTOM11,  CUSTOM12,
  CUSTOM13,  CUSTOM14,  CUSTOM15,
  CAST(NULL AS NUMBER) CUSTOM16,
  CAST(NULL AS NUMBER) CUSTOM17,
  CAST(NULL AS NUMBER) CUSTOM18,
  CAST(NULL AS NUMBER) CUSTOM19,
  CAST(NULL AS NUMBER) CUSTOM20,
  CAST(NULL AS NUMBER) CUSTOM21,
  CAST(NULL AS NUMBER) CUSTOM22,
  CAST(NULL AS NUMBER) CUSTOM23,
  CAST(NULL AS NUMBER) CUSTOM24,
  CAST(NULL AS NUMBER) CUSTOM25,
  CAST(NULL AS NUMBER) CUSTOM26,
  CAST(NULL AS NUMBER) CUSTOM27,
  CAST(NULL AS NUMBER) CUSTOM28,
  CAST(NULL AS NUMBER) CUSTOM29,
  CAST(NULL AS NUMBER) CUSTOM30
FROM
  PA_AC_ACTUAL_CUBE_VIEW v ,
  pa_projects_all p
  where p.project_id = v.pa_project_dim
  and PA_olap_PVT.G_pjt_rollup_flag  = ''Y''
  union all
  SELECT
  PROJECT_ID,  PROJECT_ORG_ID,  PROJECT_ORGANIZATION_ID,  PROJECT_ELEMENT_ID,  TIME_ID,  PERIOD_TYPE_ID,  CALENDAR_TYPE,  WBS_ROLLUP_FLAG,  PRG_ROLLUP_FLAG,
  CURR_RECORD_TYPE_ID,  CURRENCY_CODE,  REVENUE,  INITIAL_FUNDING_AMOUNT,  INITIAL_FUNDING_COUNT,  ADDITIONAL_FUNDING_AMOUNT,  ADDITIONAL_FUNDING_COUNT,
  CANCELLED_FUNDING_AMOUNT,  CANCELLED_FUNDING_COUNT,  FUNDING_ADJUSTMENT_AMOUNT,  FUNDING_ADJUSTMENT_COUNT,  REVENUE_WRITEOFF,  AR_INVOICE_AMOUNT,  AR_INVOICE_COUNT,
  AR_CASH_APPLIED_AMOUNT,  AR_INVOICE_WRITE_OFF_AMOUNT,  AR_INVOICE_WRITEOFF_COUNT,  AR_CREDIT_MEMO_AMOUNT,  AR_CREDIT_MEMO_COUNT,  UNBILLED_RECEIVABLES,
  UNEARNED_REVENUE,  AR_UNAPPR_INVOICE_AMOUNT,  AR_UNAPPR_INVOICE_COUNT,  AR_APPR_INVOICE_AMOUNT,  AR_APPR_INVOICE_COUNT,  AR_AMOUNT_DUE,  AR_COUNT_DUE,  AR_AMOUNT_OVERDUE,
  AR_COUNT_OVERDUE,  DORMANT_BACKLOG_INACTIV,  DORMANT_BACKLOG_START,  LOST_BACKLOG,  ACTIVE_BACKLOG,  REVENUE_AT_RISK,  LAST_UPDATE_DATE,  LAST_UPDATED_BY,  CREATION_DATE,
  CREATED_BY,  LAST_UPDATE_LOGIN,  CUSTOM1,  CUSTOM2,  CUSTOM3,  CUSTOM4,  CUSTOM5,  CUSTOM6,  CUSTOM7,  CUSTOM8,  CUSTOM9,  CUSTOM10,  CUSTOM11,  CUSTOM12,
  CUSTOM13,  CUSTOM14,  CUSTOM15,
  CAST(NULL AS NUMBER) CUSTOM16,
  CAST(NULL AS NUMBER) CUSTOM17,
  CAST(NULL AS NUMBER) CUSTOM18,
  CAST(NULL AS NUMBER) CUSTOM19,
  CAST(NULL AS NUMBER) CUSTOM20,
  CAST(NULL AS NUMBER) CUSTOM21,
  CAST(NULL AS NUMBER) CUSTOM22,
  CAST(NULL AS NUMBER) CUSTOM23,
  CAST(NULL AS NUMBER) CUSTOM24,
  CAST(NULL AS NUMBER) CUSTOM25,
  CAST(NULL AS NUMBER) CUSTOM26,
  CAST(NULL AS NUMBER) CUSTOM27,
  CAST(NULL AS NUMBER) CUSTOM28,
  CAST(NULL AS NUMBER) CUSTOM29,
  CAST(NULL AS NUMBER) CUSTOM30
FROM
  pji_ac_xbs_accum_f
  where PA_olap_PVT.G_pjt_rollup_flag  = ''N''';

Line: 152


  select v.text into lv_text
  from   user_views v
  where  view_name = x_lv_name;

Line: 192


procedure  update_cube
as

begin


 /*
dbms_cube_log.table_create(dbms_cube_log.type_build);

Line: 256


procedure delete_aw
as

aw_count  number ;

Line: 264


select count(*) into aw_count
from user_aws s
where aw_name = 'PA_PPR_AW';