APPS.OPI_EDW_OPI_JOB_RSRC_F_C dependencies on OPI_EDW_JOB_RSRC_FSTG

Line 218: Insert Into opi_edw_job_rsrc_fstg

214:
215:
216: l_mau := nvl( edw_currency.get_mau, 0.01 );
217:
218: Insert Into opi_edw_job_rsrc_fstg
219: (
220: JOB_RSRC_PK,
221: ACT_RSRC_COUNT,
222: PLN_RSRC_COUNT,

Line 414: l_staging_table :='OPI_EDW_JOB_RSRC_FSTG';

410: -- -------------------------------------------
411:
412: BEGIN
413: l_fact_name :='OPI_EDW_JOB_RSRC_F' ;
414: l_staging_table :='OPI_EDW_JOB_RSRC_FSTG';
415: l_exception_msg :=Null;
416:
417: l_from_date := NULL;
418: l_to_date := NULL;

Line 672: opi_edw_job_rsrc_fstg

668: for each view type instead of (Push_To_Local 1 -> Push_To_Local 2 -> Delete_Stg)
669: */
670:
671: delete
672: opi_edw_job_rsrc_fstg
673: where
674: collection_status in ('RATE NOT AVAILABLE','INVALID CURRENCY') ;
675:
676: COMMIT ;

Line 715: opi_edw_job_rsrc_fstg

711: nvl(substrb(TRX_DATE_FK,1,10),CREATION_DATE) c_date,
712: collection_status collection_status,
713: job_rsrc_pk job_rsrc_pk
714: from
715: opi_edw_job_rsrc_fstg
716: where
717: job_rsrc_pk like '%OPI'
718: and collection_status in ('RATE NOT AVAILABLE','INVALID CURRENCY')
719: /*