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_CHR_STAGE_INC

Line 217: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC' ;

213: retcode := 0;
214:
215: IF (FND_INSTALLATION.GET_APP_INFO('OKI', l_status, l_industry, l_oki_schema)) THEN
216:
217: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC' ;
218: EXECUTE IMMEDIATE l_sql_string ;
219: rlog( 'Truncated Table OKI_DBI_CHR_STAGE_INC',2);
220:
221: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_INC' ;

Line 219: rlog( 'Truncated Table OKI_DBI_CHR_STAGE_INC',2);

215: IF (FND_INSTALLATION.GET_APP_INFO('OKI', l_status, l_industry, l_oki_schema)) THEN
216:
217: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC' ;
218: EXECUTE IMMEDIATE l_sql_string ;
219: rlog( 'Truncated Table OKI_DBI_CHR_STAGE_INC',2);
220:
221: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_INC' ;
222: EXECUTE IMMEDIATE l_sql_string ;
223: rlog( 'Truncated Table OKI_DBI_CHR_INC',2);

Line 560: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

556: , 1000)
557: INTO l_batch_size
558: FROM DUAL ;
559:
560: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
561:
562: SELECT MAX(renewal_id),MAX(ren_con_id)
563: INTO g_renewal_id,g_ren_con_id
564: from

Line 572: INSERT /+ append / INTO OKI_DBI_CHR_STAGE_INC

568: WHERE clsop.cls_code='SERVICE'
569: AND clsop.opn_code in ('RENEWAL','REN_CON')
570: );
571:
572: INSERT /*+ append */ INTO OKI_DBI_CHR_STAGE_INC
573: ( id,
574: currency_code,
575: date_approved,
576: creation_date,

Line 658: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;

654: AND h.scs_code IN ('SERVICE','WARRANTY') ;
655:
656: l_count := SQL%ROWCOUNT ;
657:
658: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;
659: COMMIT;
660:
661: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
662:

Line 661: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');

657:
658: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;
659: COMMIT;
660:
661: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
662:
663: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
664: fnd_date.date_to_displayDT(SYSDATE),1) ;
665:

Line 663: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||

659: COMMIT;
660:
661: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
662:
663: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
664: fnd_date.date_to_displayDT(SYSDATE),1) ;
665:
666: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
667:

Line 865: FROM oki_dbi_chr_stage_inc h

861: , h.Ship_to_site_use_id
862: , h.inv_organization_id
863: , h.subsequent_renewal_type_code /* for ER#5760744 */
864: , h.hdr_term_cancel_source /* for ER6684955 */
865: FROM oki_dbi_chr_stage_inc h
866: UNION
867: SELECT /*+ leading(inc) use_hash(h,ren_rel,a)
868: parallel(inc) parallel(h) parallel(ren_rel) parallel(a) */
869: h.id

Line 902: FROM oki_dbi_chr_stage_inc inc

898: 'DNR', 'DNR',
899: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
900: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
901: ,h.term_cancel_source hdr_term_cancel_source /* for ER6684955 */
902: FROM oki_dbi_chr_stage_inc inc
903: , okc_k_headers_all_b h
904: , okc_operation_lines ren_rel
905: , oki_dbi_chr_stage_inc inc2
906: , okc_operation_instances opins

Line 905: , oki_dbi_chr_stage_inc inc2

901: ,h.term_cancel_source hdr_term_cancel_source /* for ER6684955 */
902: FROM oki_dbi_chr_stage_inc inc
903: , okc_k_headers_all_b h
904: , okc_operation_lines ren_rel
905: , oki_dbi_chr_stage_inc inc2
906: , okc_operation_instances opins
907: WHERE 1=1
908: AND ren_rel.object_chr_id = h.ID
909: AND ren_rel.subject_chr_id = inc.id

Line 1120: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC';

1116: , status => l_status
1117: , industry => l_industry
1118: , oracle_schema => l_oki_schema )) THEN
1119:
1120: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC';
1121: EXECUTE IMMEDIATE l_sql_string;
1122: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC',1);
1123:
1124: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_INC';

Line 1122: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC',1);

1118: , oracle_schema => l_oki_schema )) THEN
1119:
1120: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC';
1121: EXECUTE IMMEDIATE l_sql_string;
1122: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CHR_STAGE_INC',1);
1123:
1124: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CHR_INC';
1125: EXECUTE IMMEDIATE l_sql_string;
1126: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CHR_INC',1);

Line 1162: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

1158: END IF;
1159:
1160: rlog ('Primary Rate Type is '||NVL(bis_common_parameters.get_rate_type,'Not Defined'),1);
1161:
1162: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1163:
1164:
1165:
1166: /* Added hint as per perf. teams recommendations*/

Line 1167: INSERT INTO OKI_DBI_CHR_STAGE_INC

1163:
1164:
1165:
1166: /* Added hint as per perf. teams recommendations*/
1167: INSERT INTO OKI_DBI_CHR_STAGE_INC
1168: ( id,
1169: currency_code,
1170: date_approved,
1171: creation_date,

Line 1241: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;

1237: AND h.scs_code IN ('SERVICE','WARRANTY') ;
1238:
1239: l_count := SQL%ROWCOUNT ;
1240:
1241: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;
1242: COMMIT;
1243:
1244: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
1245:

Line 1244: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');

1240:
1241: rlog( 'Number of contracts inserted into OKI_DBI_CHR_STAGE_INC : '||to_char(l_count), 2) ;
1242: COMMIT;
1243:
1244: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
1245:
1246: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
1247: fnd_date.date_to_displayDT(SYSDATE),1) ;
1248:

Line 1246: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||

1242: COMMIT;
1243:
1244: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
1245:
1246: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
1247: fnd_date.date_to_displayDT(SYSDATE),1) ;
1248:
1249: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1250:

Line 1595: FROM oki_dbi_chr_stage_inc inc

1591: , inc.inv_organization_id
1592: , 1 gsd_flag
1593: , subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
1594: , inc.hdr_term_cancel_source /* Added for ER 6684955 */
1595: FROM oki_dbi_chr_stage_inc inc
1596: UNION ALL
1597: SELECT /*+ ordered cardinality(inc,10) */
1598: h.id
1599: , h.currency_code

Line 1633: FROM oki_dbi_chr_stage_inc inc ,

1629: 'DNR', 'DNR',
1630: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
1631: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
1632: , h.term_cancel_source hdr_term_cancel_source /* Added for ER 6684955 */
1633: FROM oki_dbi_chr_stage_inc inc ,
1634: okc_operation_lines ren_rel ,
1635: okc_operation_instances opins,
1636: okc_k_headers_all_b h
1637: WHERE 1=1