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.IGP_VW_GEN_001_PKG dependencies on IGP_US_PORTFOLIOS

Line 189: FROM igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz

185: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
186: SELECT ''||(RPAD(NVL(port.portfolio_name, nbsp), 80))||'' name,
187: ''||(RPAD(NVL(NVL(p_expdate,' '),nbsp), 13))||'' pub_end_date,
188: ''||(RPAD(NVL((hz.person_last_name||','||hz.person_first_name),nbsp), 360))||'' AUTHOR
189: FROM igp_us_portfolios port, igp_ac_accounts acc, hz_parties hz
190: WHERE port.account_id = acc.account_id AND
191: acc.party_id = hz.party_id AND
192: port.portfolio_id = cp_port_ids ;
193: rec_port_info c_port_info%ROWTYPE;

Line 551: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd

547: nbsp VARCHAR2(10);
548:
549: CURSOR c_port_info(cp_port_ids IN NUMBER) IS
550: SELECT port.portfolio_name, fnd.user_name
551: FROM igp_us_portfolios port, igp_ac_accounts acc, fnd_user fnd
552: WHERE port.account_id = acc.account_id AND
553: fnd.user_id = acc.user_id AND
554: port.portfolio_id = cp_port_ids ;
555: