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.OZF_OFFER_ADJ_PVT dependencies on QP_LIST_HEADERS_B

Line 127: ,qp_list_headers_b h

123: INTO l_headerStDt
124: ,l_lineStDt
125: ,l_effectiveDt
126: FROM ozf_offer_adjustments_b a
127: ,qp_list_headers_b h
128: ,qp_list_lines l
129: WHERE a.list_header_id = h.list_header_id
130: and a.list_header_id = l.list_header_id
131: and l.list_line_id = p_listLineId

Line 1894: , qp_list_headers_b d

1890: FROM
1891: qp_list_lines a
1892: , ozf_related_deal_lines b
1893: , qp_list_lines c
1894: , qp_list_headers_b d
1895: WHERE
1896: a.list_line_id = b.modifier_id
1897: AND b.related_modifier_id = c.list_line_id(+)
1898: AND a.list_header_id = d.list_header_id

Line 4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c

4111: )
4112: IS
4113: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4114: SELECT a.effective_date , b.start_date_active , a.list_header_id , c.offer_type , c.object_version_number
4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4116: WHERE a.list_header_id = b.list_header_id
4117: AND b.list_header_id = c.qp_list_header_id
4118: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4119: