APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on OPI_EDW_OPM_JOB_DETAIL_INC

Line 52: OPI_EDW_OPM_JOB_DETAIL_INC

48: AND SUBSTRB(JOB_DETAIL_PK,instrB(JOB_DETAIL_PK,'-',1,1)+1,
49: instrB(JOB_DETAIL_PK,'-',1,2)-1-instrB(JOB_DETAIL_PK,'-',1,1))
50: in (select BATCH_ID from PM_MATL_DTL WHERE
51: LINE_ID in (select PRIMARY_KEY from
52: OPI_EDW_OPM_JOB_DETAIL_INC
53: WHERE SEQ_ID is NULL));
54:
55: BEGIN
56: /* Print Header */

Line 87: DELETE OPI_EDW_OPM_JOB_DETAIL_INC;

83: IS
84: l_count number;
85: BEGIN
86: /* Delete the incremental table before inserting new data */
87: DELETE OPI_EDW_OPM_JOB_DETAIL_INC;
88: edw_log.put_line(' ');
89: edw_log.Put_line('Identifying Missing Rate Rows ');
90: edw_log.put_line(' ');
91: SELECT count(*) into l_count from OPI_EDW_JOB_DETAIL_FSTG where

Line 98: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */

94: IF l_count > 0 THEN
95:
96:
97: /* insert into Incremental table all line_id where Currency is missing */
98: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */
99: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)
100: SELECT
101: LINE_ID,
102: 1,

Line 99: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)

95:
96:
97: /* insert into Incremental table all line_id where Currency is missing */
98: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */
99: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)
100: SELECT
101: LINE_ID,
102: 1,
103: NULL

Line 370: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */

366: BEGIN
367: p_count := 0;
368: select OPI_EDW_JOB_DETAIL_INC_S.nextval into l_seq_id from dual;
369: /* insert into Incremental table all line_id but not part of missing currency convenrsion rows */
370: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */
371: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)
372: SELECT
373: LINE_ID,
374: 1,

Line 371: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)

367: p_count := 0;
368: select OPI_EDW_JOB_DETAIL_INC_S.nextval into l_seq_id from dual;
369: /* insert into Incremental table all line_id but not part of missing currency convenrsion rows */
370: INSERT /*+ parallel(OPI_EDW_OPM_JOB_DETAIL_INC) */
371: into OPI_EDW_OPM_JOB_DETAIL_INC(PRIMARY_KEY,view_id,seq_id)
372: SELECT
373: LINE_ID,
374: 1,
375: l_seq_id

Line 385: from OPI_EDW_OPM_JOB_DETAIL_INC

381: AND GREATEST(BH.LAST_UPDATE_DATE, BD.LAST_UPDATE_DATE)
382: BETWEEN g_push_from_date and g_push_to_date
383: AND LINE_ID not in
384: (SELECT PRIMARY_KEY
385: from OPI_EDW_OPM_JOB_DETAIL_INC
386: WHERE SEQ_ID is NULL);
387:
388: p_count := sql%rowcount;
389:

Line 391: Update OPI_EDW_OPM_JOB_DETAIL_INC set view_id=1,seq_id=l_seq_id

387:
388: p_count := sql%rowcount;
389:
390: /* Update the Missing Currency convenrsion rows with new Sequence */
391: Update OPI_EDW_OPM_JOB_DETAIL_INC set view_id=1,seq_id=l_seq_id
392: WHERE seq_id is NULL;
393:
394: p_count:=p_count+sql%rowcount;
395:

Line 400: TABNAME => 'OPI_EDW_OPM_JOB_DETAIL_INC');

396: Commit;
397:
398: IF (FND_INSTALLATION.GET_APP_INFO('OPI', l_status, l_industry, l_OPI_schema)) THEN
399: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_OPI_schema,
400: TABNAME => 'OPI_EDW_OPM_JOB_DETAIL_INC');
401: END IF;
402:
403: edw_log.put_line('Sequence is '||to_char(l_seq_id));
404: RETURN(l_seq_id);