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.PV_SEED_DERIVED_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 9: from oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c

5: is
6:
7: cursor lc_get_date (pc_partner_id number) is
8: select to_char(aa.ordered_date,'yyyymmddhh24miss')
9: from oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c
10: where c.partner_id = pc_partner_id
11: and c.partner_party_id = b.party_id
12: and b.cust_account_id = aa.sold_to_org_id
13: order by aa.ordered_date desc;

Line 34: from oe_order_lines_all a, oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c

30: is
31:
32: cursor lc_prod_bought (pc_partner_id number) is
33: select distinct a.inventory_item_id
34: from oe_order_lines_all a, oe_order_headers_all aa, hz_cust_accounts b, pv_partner_profiles c
35: where c.partner_id = pc_partner_id
36: and c.partner_party_id = b.party_id and b.cust_account_id = aa.invoice_to_org_id
37: and aa.ordered_date > add_months(sysdate, -12)
38: and aa.header_id = a.header_id