APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C dependencies on OPI_EDW_OPMINV_DAILY_STAT_INC

Line 82: DELETE OPI_EDW_OPMINV_DAILY_STAT_INC WHERE SEQ_ID IS NOT NULL;

78: IS
79: l_count number;
80: BEGIN
81: /* Delete the incremental table before inserting new data */
82: DELETE OPI_EDW_OPMINV_DAILY_STAT_INC WHERE SEQ_ID IS NOT NULL;
83: edw_log.put_line(' ');
84: edw_log.Put_line('Identifying Missing Rate Rows ');
85: edw_log.put_line(' ');
86: SELECT count(*) into l_count from opi_edw_inv_daily_stat_fstg where

Line 91: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */

87: COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
88: AND INV_DAILY_STATUS_PK like '%OPM';
89: IF l_count > 0 THEN
90: /* insert into Incremental table all line_id where Currency is missing */
91: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */
92: into OPI_EDW_OPMINV_DAILY_STAT_INC
93: ( PRIMARY_KEY,
94: PRIMARY_KEY1,
95: PRIMARY_KEY2,

Line 92: into OPI_EDW_OPMINV_DAILY_STAT_INC

88: AND INV_DAILY_STATUS_PK like '%OPM';
89: IF l_count > 0 THEN
90: /* insert into Incremental table all line_id where Currency is missing */
91: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */
92: into OPI_EDW_OPMINV_DAILY_STAT_INC
93: ( PRIMARY_KEY,
94: PRIMARY_KEY1,
95: PRIMARY_KEY2,
96: PRIMARY_KEY3,

Line 161: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */

157: BEGIN
158: p_count := 0;
159: select OPI_EDW_OPMINV_DAILY_INC_S.nextval into l_seq_id from dual;
160: /* insert into Incremental table all line_id but not part of missing currency convenrsion rows */
161: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */
162: into OPI_EDW_OPMINV_DAILY_STAT_INC
163: ( PRIMARY_KEY,
164: PRIMARY_KEY1,
165: PRIMARY_KEY2,

Line 162: into OPI_EDW_OPMINV_DAILY_STAT_INC

158: p_count := 0;
159: select OPI_EDW_OPMINV_DAILY_INC_S.nextval into l_seq_id from dual;
160: /* insert into Incremental table all line_id but not part of missing currency convenrsion rows */
161: INSERT /*+ parallel(OPI_EDW_OPMINV_DAILY_STAT_INC) */
162: into OPI_EDW_OPMINV_DAILY_STAT_INC
163: ( PRIMARY_KEY,
164: PRIMARY_KEY1,
165: PRIMARY_KEY2,
166: PRIMARY_KEY3,

Line 189: from OPI_EDW_OPMINV_DAILY_STAT_INC

185: AND CO_CODE||ORGN_CODE||WHSE_CODE||LOCATION||ITEM_ID||LOT_ID||TRX_DATE
186: not in
187: (SELECT PRIMARY_KEY||PRIMARY_KEY1||PRIMARY_KEY2||PRIMARY_KEY3||PRIMARY_KEY4
188: ||PRIMARY_KEY5||PRIMARY_KEY6
189: from OPI_EDW_OPMINV_DAILY_STAT_INC
190: WHERE SEQ_ID is NULL);
191:
192: p_count := sql%rowcount;
193:

Line 195: Update OPI_EDW_OPMINV_DAILY_STAT_INC set view_id=1,seq_id=l_seq_id

191:
192: p_count := sql%rowcount;
193:
194: /* Update the Missing Currency convenrsion rows with new Sequence */
195: Update OPI_EDW_OPMINV_DAILY_STAT_INC set view_id=1,seq_id=l_seq_id
196: WHERE seq_id is NULL;
197:
198: p_count := p_count+sql%rowcount;
199:

Line 204: TABNAME => 'OPI_EDW_OPMINV_DAILY_STAT_INC');

200: Commit;
201:
202: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_OPI_schema)) THEN
203: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_OPI_schema,
204: TABNAME => 'OPI_EDW_OPMINV_DAILY_STAT_INC');
205: END IF;
206:
207: edw_log.put_line('Sequence is '||to_char(l_seq_id));
208: RETURN(l_seq_id);

Line 570: from OPI_EDW_OPMINV_DAILY_STAT_INC

566: CO_CODE||ORGN_CODE||WHSE_CODE||LOCATION||ITEM_ID||LOT_ID||TRX_DATE
567: not in
568: (SELECT PRIMARY_KEY||PRIMARY_KEY1||PRIMARY_KEY2||PRIMARY_KEY3||PRIMARY_KEY4
569: ||PRIMARY_KEY5||PRIMARY_KEY6
570: from OPI_EDW_OPMINV_DAILY_STAT_INC
571: WHERE SEQ_ID is NULL);
572:
573: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
574: g_push_from_date, g_push_to_date);