DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on RA_TERMS_TL

Line 1865: hz_parties p, hz_cust_accounts c, ra_terms_tl t,

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

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