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 OE_AGREEMENTS_LOV_V

Line 1864: FROM oe_agreements_lov_v a, qp_list_headers_vl q,

1860: IS
1861: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1862: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1863: t.name payment_term_name, a.start_date_active, a.end_date_active
1864: FROM oe_agreements_lov_v a, qp_list_headers_vl q,
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 (

Line 1903: from oe_agreements_lov_v a, qp_list_headers_vl q, ra_terms_tl t,

1899: IS
1900: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1901: a.agreement_type, q.name price_list_name, null customer_name,
1902: t.name payment_term_name, a.start_date_active, a.end_date_active
1903: from oe_agreements_lov_v a, qp_list_headers_vl q, ra_terms_tl t,
1904: oe_transaction_types_all ot
1905: where l_temp_date between
1906: trunc(nvl(a.start_date_active, add_months(sysdate, -10000))) and
1907: trunc(nvl(a.end_date_active, add_months(sysdate, +10000))) and

Line 1925: from oe_agreements_lov_v a, qp_list_headers_vl q,

1921: IS
1922: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1923: a.agreement_type, q.name price_list_name, p.party_name customer_name,
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

Line 1957: FROM oe_agreements_lov_v a, qp_list_headers_vl q

1953: IS
1954: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1955: a.agreement_type, q.name price_list_name, NULL customer_name,
1956: NULL payment_term_name, a.start_date_active, a.end_date_active
1957: FROM oe_agreements_lov_v a, qp_list_headers_vl q
1958: --, qp_list_headers_b l
1959: WHERE l_temp_date BETWEEN
1960: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1961: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND