APPS.OPI_EDW_OPI_JOB_RSRC_F_C dependencies on OPI_EDW_OPI_JOB_RSRC_MR_TMP

Line 96: opi_edw_opi_job_rsrc_mr_tmp

92: primary_key6,
93: l_seq_id, /* NOTE : THIS IS THE NEW SEQ_ID */
94: view_id
95: from
96: opi_edw_opi_job_rsrc_mr_tmp
97: where
98: view_id = 1 ;
99:
100: ELSIF p_view_id = 2 THEN

Line 163: opi_edw_opi_job_rsrc_mr_tmp

159: primary_key6,
160: l_seq_id, /* NOTE : THIS IS THE NEW SEQ_ID */
161: view_id
162: from
163: opi_edw_opi_job_rsrc_mr_tmp
164: where
165: view_id = 2 ;
166:
167: END IF;

Line 173: opi_edw_opi_job_rsrc_mr_tmp

169: l_count1 := SQL%rowcount ;
170:
171:
172: delete
173: opi_edw_opi_job_rsrc_mr_tmp
174: where
175: view_id = p_view_id ;
176:
177: l_count2 := SQL%rowcount ;

Line 770: INSERT INTO opi_edw_opi_job_rsrc_mr_tmp

766: l_primary_key5 := to_number(substrb(l_currency_cur.job_rsrc_pk,l_primary_key4_pos + 1, l_primary_key5_pos - l_primary_key4_pos - 1)) ;
767:
768: -- Insert Records with seq_id = NULL
769:
770: INSERT INTO opi_edw_opi_job_rsrc_mr_tmp
771: (primary_key1,primary_key2,primary_key3,primary_key4,primary_key5,primary_key6,view_id)
772: VALUES
773: (l_primary_key1,l_primary_key2,l_primary_key3,l_primary_key4,l_primary_key5,'OPI',l_view_id);
774: