eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKI_DBI_CLE_DEL

Line 2136: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_DEL' ;

2132: , status => l_status
2133: , industry => l_industry
2134: , oracle_schema => l_oki_schema)) THEN
2135:
2136: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_DEL' ;
2137: EXECUTE IMMEDIATE l_sql_string ;
2138:
2139: INSERT /*+ APPEND */ INTO oki_dbi_cle_del
2140: (cle_id)

Line 2139: INSERT /+ APPEND / INTO oki_dbi_cle_del

2135:
2136: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema ||'.OKI_DBI_CLE_DEL' ;
2137: EXECUTE IMMEDIATE l_sql_string ;
2138:
2139: INSERT /*+ APPEND */ INTO oki_dbi_cle_del
2140: (cle_id)
2141: SELECT /*+ index_ffs(f OKI_DBI_CLE_B_U1) parallel_index(f OKI_DBI_CLE_B_U1) */
2142: f.cle_id
2143: FROM oki_dbi_cle_b f

Line 2157: FROM oki_dbi_cle_del

2153:
2154: IF ( g_del_count > 0 ) THEN
2155: DELETE FROM oki_dbi_cle_b
2156: WHERE cle_id IN ( SELECT cle_id
2157: FROM oki_dbi_cle_del
2158: );
2159: l_count := SQL%ROWCOUNT;
2160: END IF;
2161: rlog('Number of lines deleted from oki_dbi_cle_b: ' ||

Line 3151: FROM oki_dbi_cle_del del1

3147: FROM (SELECT /*+ ordered use_nl(del,rl,opins,clsop) */
3148: del.cle_id
3149: , MAX(rl.subject_cle_id) KEEP (DENSE_RANK LAST
3150: ORDER BY rl.last_update_date) r_cle_id
3151: FROM oki_dbi_cle_del del1
3152: , oki_dbi_cle_b del
3153: , okc_operation_lines rl
3154: , okc_operation_instances opins
3155: , okc_class_operations clsop

Line 3599: l_sql_string := 'TRUNCATE TABLE '||l_oki_schema||'.oki_dbi_Cle_del';

3595: ELSIF (l_phase = 4 ) THEN
3596:
3597: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_PREV_INC');
3598:
3599: l_sql_string := 'TRUNCATE TABLE '||l_oki_schema||'.oki_dbi_Cle_del';
3600: EXECUTE IMMEDIATE l_sql_string;
3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '

Line 3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);

3597: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_PREV_INC');
3598:
3599: l_sql_string := 'TRUNCATE TABLE '||l_oki_schema||'.oki_dbi_Cle_del';
3600: EXECUTE IMMEDIATE l_sql_string;
3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '
3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3605: INSERT INTO OKI_DBI_CLE_DEL

Line 3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '

3599: l_sql_string := 'TRUNCATE TABLE '||l_oki_schema||'.oki_dbi_Cle_del';
3600: EXECUTE IMMEDIATE l_sql_string;
3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '
3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3605: INSERT INTO OKI_DBI_CLE_DEL
3606: ( cle_id
3607: ,worker_number)

Line 3605: INSERT INTO OKI_DBI_CLE_DEL

3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '
3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3605: INSERT INTO OKI_DBI_CLE_DEL
3606: ( cle_id
3607: ,worker_number)
3608: (SELECT
3609: cle_id

Line 3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '

3626: );
3627:
3628: COMMIT;
3629:
3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '
3631: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3632:
3633: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_DEL');
3634:

Line 3633: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_DEL');

3629:
3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '
3631: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3632:
3633: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_DEL');
3634:
3635: END IF;
3636:
3637: IF ( l_phase < 7 ) THEN

Line 6332: FROM oki_dbi_cle_del ren_inc ,

6328: , b.negotiation_status /* Added part of ER#5950128 */
6329: , b.reminder /* Added part of ER#5950128 */
6330: , b.HDR_TERM_CANCEL_SOURCE /* ER 6684955 */
6331: , b.SL_TERM_CANCEL_SOURCE /* ER 6684955 */
6332: FROM oki_dbi_cle_del ren_inc ,
6333: oki_dbi_cle_b b
6334: WHERE b.cle_id = ren_inc.cle_id
6335: AND ren_inc.worker_number = p_worker
6336: AND NOT EXISTS