APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_REQUEST_HEADERS_ALL_VL

Line 178: FROM ozf_request_headers_all_vl a

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

Line 1058: FROM ozf_request_headers_all_vl a

1054: a.reseller_party_id,
1055: a.offer_id,
1056: a.offer_type,
1057: a.ship_from_stock_flag --POS Batch Processing by profiles by ateotia
1058: FROM ozf_request_headers_all_vl a
1059: WHERE a.agreement_number = p_agreement_num
1060: AND a.status_code = 'APPROVED'
1061: AND a.partner_id = p_partner_id
1062: AND a.request_class = G_SPECIAL_PRICE_CLASS;

Line 1104: ozf_request_headers_all_vl b

1100: a.approved_amount,
1101: a.approved_max_qty,
1102: a.approved_min_qty
1103: FROM ozf_request_lines_all a,
1104: ozf_request_headers_all_vl b
1105: WHERE a.item_type = 'PRODUCT'
1106: AND a.item_id = p_inventory_id
1107: AND a.request_header_id = b.request_header_id
1108: AND b.agreement_number = p_agreement_num