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.QP_UTIL_PUB dependencies on DUAL

Line 1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual

1535: hz_parties p, hz_cust_accounts c, ra_terms_tl t,
1536: -- qp_list_headers_b l,
1537: oe_transaction_types_all ot
1538: WHERE a.sold_to_org_id IN (
1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1540: UNION
1541: SELECT -1 FROM dual
1542: UNION
1543: SELECT r.cust_account_id FROM hz_cust_acct_relate r

Line 1541: SELECT -1 FROM dual

1537: oe_transaction_types_all ot
1538: WHERE a.sold_to_org_id IN (
1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1540: UNION
1541: SELECT -1 FROM dual
1542: UNION
1543: SELECT r.cust_account_id FROM hz_cust_acct_relate r
1544: WHERE r.related_cust_account_id = p_sold_to_org_id AND
1545: l_cust_relation_flag = 'Y' AND

Line 1598: select to_number(p_sold_to_org_id) from dual

1594: null payment_term_name, a.start_date_active, a.end_date_active
1595: from oe_agreements_lov_v a, qp_list_headers_vl q,
1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1597: where a.sold_to_org_id in (
1598: select to_number(p_sold_to_org_id) from dual
1599: union
1600: select -1 from dual
1601: union
1602: select r.cust_account_id from hz_cust_acct_relate r

Line 1600: select -1 from dual

1596: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1597: where a.sold_to_org_id in (
1598: select to_number(p_sold_to_org_id) from dual
1599: union
1600: select -1 from dual
1601: union
1602: select r.cust_account_id from hz_cust_acct_relate r
1603: where r.related_cust_account_id = p_sold_to_org_id and
1604: l_cust_relation_flag = 'Y' and