APPS.OPI_EDW_COGS_F_C dependencies on OPI_EDW_COGS_FSTG

Line 228: Insert Into opi_edw_cogs_fstg

224: -- progress until all the child processes have
225: -- completed successfully.
226: -- ------------------------------------------------
227:
228: Insert Into opi_edw_cogs_fstg
229: (
230: ACCOUNT,
231: BASE_CURRENCY_FK,
232: BASE_UOM_FK,

Line 466: l_staging_table VARCHAR2(30) :='OPI_EDW_COGS_FSTG';

462: p_from_date IN varchar2,
463: p_to_date IN varchar2) IS
464:
465: l_fact_name VARCHAR2(30) :='OPI_EDW_COGS_F' ;
466: l_staging_table VARCHAR2(30) :='OPI_EDW_COGS_FSTG';
467: l_opi_schema VARCHAR2(30);
468: l_status VARCHAR2(30);
469: l_industry VARCHAR2(30);
470: l_exception_msg VARCHAR2(2000):=Null;

Line 491: FROM opi_edw_cogs_fstg

487: SELECT DISTINCT
488: base_currency_fk from_currency,
489: Substr(cogs_date_fk, 1,10) c_date,
490: collection_status
491: FROM opi_edw_cogs_fstg
492: WHERE collection_status IN ('RATE NOT AVAILABLE','INVALID CURRENCY')
493: AND Substr(cogs_pk,0,3) <> 'OPM'
494: ORDER BY from_currency, c_date;
495:

Line 682: FROM opi_edw_cogs_fstg

678: Instr(cogs_pk,'-', 1, 3)- Instr(cogs_pk, '-',1,2)-1)
679: ) primary_key1,
680: Decode(Substr(cogs_pk,0,3), 'INV', NULL, 'RMA', NULL,
681: 'ICI', Substr(cogs_pk,5,Instr(cogs_pk,'-',1,2) -5)) primary_key2
682: FROM opi_edw_cogs_fstg
683: WHERE collection_status IN ('RATE NOT AVAILABLE','INVALID CURRENCY')
684: AND Substr(cogs_pk,0,3) <> 'OPM'
685: ;
686:

Line 708: DELETE opi_edw_cogs_fstg

704: -- if on single instance, delete records with
705: -- 'RATE NOT AVAILABLE','INVALID CURRENCY' from fstg
706: -- --------------------------------------------------------
707: IF local_same_as_remote THEN
708: DELETE opi_edw_cogs_fstg
709: WHERE collection_status IN ('RATE NOT AVAILABLE','INVALID CURRENCY')
710: AND Substr(cogs_pk,0,3) <> 'OPM';
711: END IF;
712: