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.

[Home] [Help]

APPS.AD_ZD_ADOP dependencies on AD_TE_LEVEL_HISTORY

Line 1023: from ad_te_level_history

1019: where PATCH_RUN_ID=x_patch_run_id;
1020:
1021: cursor tes is
1022: select distinct abbreviation
1023: from ad_te_level_history
1024: where patch_run_id=x_patch_run_id;
1025:
1026: begin
1027:

Line 1041: delete AD_TE_LEVEL_HISTORY

1037:
1038: -- Cleaning Codelevels
1039: for te in tes
1040: loop
1041: delete AD_TE_LEVEL_HISTORY
1042: where patch_run_id=x_patch_run_id and abbreviation=te.abbreviation;
1043:
1044: begin
1045: select max(baseline), max(codelevel)

Line 1047: from AD_TE_LEVEL_HISTORY

1043:
1044: begin
1045: select max(baseline), max(codelevel)
1046: into v_blvl, v_clvl
1047: from AD_TE_LEVEL_HISTORY
1048: where abbreviation=te.abbreviation;
1049:
1050: update ad_trackable_entities
1051: set baseline=v_blvl, codelevel=v_clvl