DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on QP_LIST_HEADERS_B

Line 132: FROM ozf_offer_adjustments_b a, ozf_offers b , qp_list_lines c , qp_list_headers_b d

128: ) endDate
129: --greatest(nvl(d.start_date_active, a.effective_date - 5 ),nvl(d.start_date_active, a.effective_date - 5 ), a.effective_date - 1 ) endDate
130: , b.offer_type, b.qp_list_header_id
131: , c.start_date_active lineStartDate, d.start_date_active headerStartDate
132: FROM ozf_offer_adjustments_b a, ozf_offers b , qp_list_lines c , qp_list_headers_b d
133: WHERE
134: a.list_header_id = b.qp_list_header_id
135: AND b.qp_list_header_id = c.list_header_id
136: AND c.list_header_id = d.list_header_id