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.AMS_DMSELECTION_PVT dependencies on BIC_PARTY_SUMM

Line 1999: FROM bic_party_summ p , hz_relationships hpr

1995: -- changed rosharma 19-jun-2003 bug # 3004453
1996: --FROM ams_dm_party_details_time p
1997: --WHERE p.party_id = t.party_id
1998: --AND p.tot_num_order_3_months < 1
1999: FROM bic_party_summ p , hz_relationships hpr
2000: WHERE hpr.party_id = t.party_id
2001: AND hpr.status = 'A'
2002: AND hpr.subject_table_name = 'HZ_PARTIES'
2003: AND hpr.object_table_name = 'HZ_PARTIES'

Line 2026: FROM bic_party_summ p

2022: -- changed rosharma 19-jun-2003 bug # 3004453
2023: --FROM ams_dm_party_details_time p
2024: --WHERE p.party_id = t.party_id
2025: --AND p.tot_num_order_3_months < 1
2026: FROM bic_party_summ p
2027: WHERE p.party_id = t.party_id
2028: HAVING SUM(DECODE(SIGN(ROUND(MONTHS_BETWEEN(l_date, p.period_start_date)) - 3),1,0,p.order_num)) >= 1
2029: -- end change rosharma 19-jun-2003 bug # 3004453
2030: )