DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_LIST_HEADERS_VL

Line 7135: FROM qp_list_headers_vl qp, ozf_offers ofr

7131:
7132: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
7133: ----- fix bug 5675871
7134: SELECT qp.description, qp.name ,nvl(ofr.transaction_currency_code, ofr.fund_request_curr_code)
7135: FROM qp_list_headers_vl qp, ozf_offers ofr
7136: WHERE qp.list_header_id = p_list_header_id
7137: AND qp.list_header_id = ofr.qp_list_header_id;
7138: /*
7139: SELECT description, name ,currency_code

Line 7140: FROM qp_list_headers_vl

7136: WHERE qp.list_header_id = p_list_header_id
7137: AND qp.list_header_id = ofr.qp_list_header_id;
7138: /*
7139: SELECT description, name ,currency_code
7140: FROM qp_list_headers_vl
7141: WHERE list_header_id = p_list_header_id;
7142: */
7143: CURSOR c_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2,p_order_line_id IN NUMBER) IS
7144: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id