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

Line 1339: ,oe_agreements oa

1335: ,qlhv.description description
1336: ,qlhv.start_date_active start_date_active
1337: ,qlhv.end_date_active end_date_active
1338: FROM qp_list_headers_vl qlhv
1339: ,oe_agreements oa
1340: ,qp_currency_details qdt
1341: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1342: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1343: OR

Line 1398: ,oe_agreements oa

1394: ,qlhv.description description
1395: ,qlhv.start_date_active start_date_active
1396: ,qlhv.end_date_active end_date_active
1397: FROM qp_list_headers_vl qlhv
1398: ,oe_agreements oa
1399: ,qp_currency_details qdt
1400: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1401: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1402: OR

Line 1509: ,oe_agreements oa

1505: ,qlhv.start_date_active start_date_active
1506: ,qlhv.end_date_active end_date_active
1507: FROM
1508: qp_list_headers_vl qlhv
1509: ,oe_agreements oa
1510: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1511: qlhv.list_type_code IN ('PRL', 'AGR'))
1512: OR
1513: qlhv.list_type_code = 'PRL'

Line 1560: ,oe_agreements oa

1556: ,qlhv.start_date_active start_date_active
1557: ,qlhv.end_date_active end_date_active
1558: FROM
1559: qp_list_headers_vl qlhv
1560: ,oe_agreements oa
1561: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1562: qlhv.list_type_code IN ('PRL', 'AGR'))
1563: OR
1564: qlhv.list_type_code = 'PRL'

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