DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_LIST_HEADERS_VL

Line 3107: FROM qp_list_headers_vl qp, ozf_offers ofr

3103:
3104: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
3105: ----- fix bug 5675871
3106: SELECT qp.description, qp.name ,nvl(ofr.transaction_currency_code, ofr.fund_request_curr_code)
3107: FROM qp_list_headers_vl qp, ozf_offers ofr
3108: WHERE qp.list_header_id = p_list_header_id
3109: AND qp.list_header_id = ofr.qp_list_header_id;
3110: /*
3111: SELECT description, name ,currency_code

Line 3112: FROM qp_list_headers_vl

3108: WHERE qp.list_header_id = p_list_header_id
3109: AND qp.list_header_id = ofr.qp_list_header_id;
3110: /*
3111: SELECT description, name ,currency_code
3112: FROM qp_list_headers_vl
3113: WHERE list_header_id = p_list_header_id;
3114: */
3115: CURSOR c_adj_info (p_price_adj_id IN NUMBER,p_object_type VARCHAR2,p_order_line_id IN NUMBER) IS
3116: SELECT distinct billto_cust_account_id, cust_account_id,product_id,object_id,object_type,org_id