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 1869: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual

1865: hz_parties p, hz_cust_accounts c, ra_terms_tl t,
1866: -- qp_list_headers_b l,
1867: oe_transaction_types_all ot
1868: WHERE a.sold_to_org_id IN (
1869: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1870: UNION
1871: SELECT -1 FROM dual
1872: UNION
1873: SELECT r.cust_account_id FROM hz_cust_acct_relate r

Line 1871: SELECT -1 FROM dual

1867: oe_transaction_types_all ot
1868: WHERE a.sold_to_org_id IN (
1869: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1870: UNION
1871: SELECT -1 FROM dual
1872: UNION
1873: SELECT r.cust_account_id FROM hz_cust_acct_relate r
1874: WHERE r.related_cust_account_id = p_sold_to_org_id AND
1875: l_cust_relation_flag = 'Y' AND

Line 1928: select to_number(p_sold_to_org_id) from dual

1924: null payment_term_name, a.start_date_active, a.end_date_active
1925: from oe_agreements_lov_v a, qp_list_headers_vl q,
1926: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1927: where a.sold_to_org_id in (
1928: select to_number(p_sold_to_org_id) from dual
1929: union
1930: select -1 from dual
1931: union
1932: select r.cust_account_id from hz_cust_acct_relate r

Line 1930: select -1 from dual

1926: hz_parties p, hz_cust_accounts c --, qp_list_headers_b l
1927: where a.sold_to_org_id in (
1928: select to_number(p_sold_to_org_id) from dual
1929: union
1930: select -1 from dual
1931: union
1932: select r.cust_account_id from hz_cust_acct_relate r
1933: where r.related_cust_account_id = p_sold_to_org_id and
1934: l_cust_relation_flag = 'Y' and