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 1009: ,oe_agreements oa

1005: ,qlhv.description description
1006: ,qlhv.start_date_active start_date_active
1007: ,qlhv.end_date_active end_date_active
1008: FROM qp_list_headers_vl qlhv
1009: ,oe_agreements oa
1010: ,qp_currency_details qdt
1011: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1012: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1013: OR

Line 1068: ,oe_agreements oa

1064: ,qlhv.description description
1065: ,qlhv.start_date_active start_date_active
1066: ,qlhv.end_date_active end_date_active
1067: FROM qp_list_headers_vl qlhv
1068: ,oe_agreements oa
1069: ,qp_currency_details qdt
1070: WHERE ( ( oa.price_list_id = qlhv.list_header_id
1071: AND qlhv.list_type_code IN ('PRL', 'AGR') )
1072: OR

Line 1179: ,oe_agreements oa

1175: ,qlhv.start_date_active start_date_active
1176: ,qlhv.end_date_active end_date_active
1177: FROM
1178: qp_list_headers_vl qlhv
1179: ,oe_agreements oa
1180: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1181: qlhv.list_type_code IN ('PRL', 'AGR'))
1182: OR
1183: qlhv.list_type_code = 'PRL'

Line 1230: ,oe_agreements oa

1226: ,qlhv.start_date_active start_date_active
1227: ,qlhv.end_date_active end_date_active
1228: FROM
1229: qp_list_headers_vl qlhv
1230: ,oe_agreements oa
1231: WHERE ( (oa.price_list_id = qlhv.list_header_id AND
1232: qlhv.list_type_code IN ('PRL', 'AGR'))
1233: OR
1234: qlhv.list_type_code = 'PRL'

Line 1534: FROM oe_agreements_lov_v a, qp_list_headers_vl q,

1530: IS
1531: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1532: a.agreement_type, q.name price_list_name, p.party_name customer_name,
1533: t.name payment_term_name, a.start_date_active, a.end_date_active
1534: FROM oe_agreements_lov_v a, qp_list_headers_vl q,
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 (

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

1569: IS
1570: select substr(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1571: a.agreement_type, q.name price_list_name, null customer_name,
1572: t.name payment_term_name, a.start_date_active, a.end_date_active
1573: from oe_agreements_lov_v a, qp_list_headers_vl q, ra_terms_tl t,
1574: oe_transaction_types_all ot
1575: where l_temp_date between
1576: trunc(nvl(a.start_date_active, add_months(sysdate, -10000))) and
1577: trunc(nvl(a.end_date_active, add_months(sysdate, +10000))) and

Line 1595: from oe_agreements_lov_v a, qp_list_headers_vl q,

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

Line 1627: FROM oe_agreements_lov_v a, qp_list_headers_vl q

1623: IS
1624: SELECT SUBSTRB(a.agreement_name,1,300) agreement_name, a.agreement_id agreement_id,
1625: a.agreement_type, q.name price_list_name, NULL customer_name,
1626: NULL payment_term_name, a.start_date_active, a.end_date_active
1627: FROM oe_agreements_lov_v a, qp_list_headers_vl q
1628: --, qp_list_headers_b l
1629: WHERE l_temp_date BETWEEN
1630: TRUNC(NVL(a.start_date_active, ADD_MONTHS(SYSDATE, -10000))) AND
1631: TRUNC(NVL(a.end_date_active, ADD_MONTHS(SYSDATE, +10000))) AND