APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_REQUEST_HEADERS_ALL_VL

Line 176: FROM ozf_request_headers_all_vl a

172: CURSOR request_header_id_csr (p_agreement_number VARCHAR2,
173: p_partner_id NUMBER) IS
174: SELECT a.request_header_id,
175: a.request_number
176: FROM ozf_request_headers_all_vl a
177: WHERE a.agreement_number = p_agreement_number
178: AND a.status_code = 'APPROVED'
179: AND a.partner_id = p_partner_id
180: AND a.request_class = G_SPECIAL_PRICE_CLASS;

Line 1000: FROM ozf_request_headers_all_vl a

996: a.end_cust_party_id,
997: a.reseller_party_id,
998: a.offer_id,
999: a.offer_type
1000: FROM ozf_request_headers_all_vl a
1001: WHERE a.agreement_number = p_agreement_num
1002: AND a.status_code = 'APPROVED'
1003: AND a.partner_id = p_partner_id
1004: AND a.request_class = G_SPECIAL_PRICE_CLASS;

Line 1028: ozf_request_headers_all_vl b

1024: a.approved_amount,
1025: a.approved_max_qty,
1026: a.approved_min_qty
1027: FROM ozf_request_lines_all a,
1028: ozf_request_headers_all_vl b
1029: WHERE a.item_type = 'PRODUCT'
1030: AND a.item_id = p_inventory_id
1031: AND a.request_header_id = b.request_header_id
1032: AND b.agreement_number = p_agreement_num