APPS.OPI_EDW_OPMCOGS_F_C dependencies on OPI_EDW_OPMCOGS_FCV

Line 97: OPI_EDW_OPMCOGS_FCV

93: SUBSTRB(ORDER_LINE_ID,1,instrB(ORDER_LINE_ID,'-',1,1)-1),
94: 1,
95: NULL
96: FROM
97: OPI_EDW_OPMCOGS_FCV
98: WHERE
99: VIEW_ID=1 AND
100: COGS_PK in ( SELECT COGS_PK
101: FROM OPI_EDW_COGS_FSTG

Line 114: OPI_EDW_OPMCOGS_FCV

110: SUBSTRB(ORDER_LINE_ID,1,instrB(ORDER_LINE_ID,'-',1,1)-1),
111: 2,
112: NULL
113: FROM
114: OPI_EDW_OPMCOGS_FCV
115: WHERE
116: VIEW_ID=2 AND
117: COGS_PK in ( SELECT COGS_PK
118: FROM OPI_EDW_COGS_FSTG

Line 370: from OPI_EDW_OPMCOGS_FCV

366: ,USER_FK5
367: ,NULL -- OPERATION_CODE
368: ,DECODE(COGS_G,-1,'RATE NOT AVAILABLE',-2,'INVALID CURRENCY','LOCAL READY')
369: ,LAST_UPDATE_DATE
370: from OPI_EDW_OPMCOGS_FCV
371: WHERE view_id = p_view_id
372: AND seq_id = p_seq_id;
373:
374: edw_log.Put_line('Insert completed in Staging tables');