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_REPROCESS_CLASSIC_UPGRADE dependencies on FND_PRODUCT_INSTALLATIONS

Line 37: l_status fnd_product_installations.status%type;

33: -- |--------------------------< get_ota_schema >------------------------------|
34: -- ----------------------------------------------------------------------------
35: function get_ota_schema return varchar2 is
36: OTA_APP_SHORT_NAME constant varchar2(10) := 'OTA';
37: l_status fnd_product_installations.status%type;
38: l_industry fnd_product_installations.industry%type;
39: l_schema FND_ORACLE_USERID.oracle_username%type := null;
40:
41: l_found boolean;

Line 38: l_industry fnd_product_installations.industry%type;

34: -- ----------------------------------------------------------------------------
35: function get_ota_schema return varchar2 is
36: OTA_APP_SHORT_NAME constant varchar2(10) := 'OTA';
37: l_status fnd_product_installations.status%type;
38: l_industry fnd_product_installations.industry%type;
39: l_schema FND_ORACLE_USERID.oracle_username%type := null;
40:
41: l_found boolean;
42: begin