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.OTA_INITIALIZATION_WF dependencies on OTA_CERTIFICATIONS_TL

Line 1589: ,ota_certifications_tl cet

1585: Select cet.name
1586: ,cet.end_date_comments
1587: ,ceb.end_date_active
1588: From ota_certifications_b ceb
1589: ,ota_certifications_tl cet
1590: Where
1591: ceb.certification_id = cet.certification_id
1592: and cet.language = userenv('LANG')
1593: and ceb.certification_id = p_certification_id;

Line 1595: l_certification_name ota_certifications_tl.name%type;

1591: ceb.certification_id = cet.certification_id
1592: and cet.language = userenv('LANG')
1593: and ceb.certification_id = p_certification_id;
1594:
1595: l_certification_name ota_certifications_tl.name%type;
1596: l_end_date_comments ota_certifications_tl.end_date_comments%type;
1597: l_end_date_active ota_certifications_b.end_date_active%type;
1598:
1599: l_process wf_activities.name%type := 'OTA_CERTIFICATION_NTF_JSP_PRC';

Line 1596: l_end_date_comments ota_certifications_tl.end_date_comments%type;

1592: and cet.language = userenv('LANG')
1593: and ceb.certification_id = p_certification_id;
1594:
1595: l_certification_name ota_certifications_tl.name%type;
1596: l_end_date_comments ota_certifications_tl.end_date_comments%type;
1597: l_end_date_active ota_certifications_b.end_date_active%type;
1598:
1599: l_process wf_activities.name%type := 'OTA_CERTIFICATION_NTF_JSP_PRC';
1600: l_item_key wf_items.item_key%type;