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.

[Home] [Help]

APPS.QP_UTIL_PUB dependencies on OE_AGREEMENTS_LOV_V

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