APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on PO_REQUISITION_HEADERS

Line 8: req_num po_requisition_headers.segment1%TYPE,

4: TYPE line_record IS RECORD (
5: req_line_id po_requisition_lines.requisition_line_id%TYPE,
6: line_num po_requisition_lines.line_num%TYPE,
7: neg_line_num po_requisition_lines.auction_line_number%TYPE,
8: req_num po_requisition_headers.segment1%TYPE,
9: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
10: item_desc po_requisition_lines.item_description%TYPE,
11: uom po_requisition_lines.unit_meas_lookup_code%TYPE,
12: quantity po_requisition_lines.quantity%TYPE,

Line 150: from po_requisition_headers_all

146: fnd_message.set_token('NEG_NUM', NegotiationNum);
147: l_message_sub1 := fnd_message.get;
148: ELSIF Source = 'WITHDRAW' THEN
149: select segment1 into x_req_num
150: from po_requisition_headers_all
151: where requisition_header_id = DocumentId;
152:
153: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SW');
154: fnd_message.set_token('NEG_NUM', NegotiationNum);

Line 294: po_requisition_headers_all rqh, --

290: null,
291: null
292: ,rql.auction_header_id --Bug 4107528
293: FROM po_requisition_lines rql,
294: po_requisition_headers_all rqh, --
295: mtl_system_items_kfv msi
296: WHERE rql.requisition_header_id = rqh.requisition_header_id
297: and rql.requisition_header_id = v_document_id
298: and rql.auction_display_number = v_negotiation_num

Line 323: po_requisition_headers_all rqh, --

319: null,
320: null
321: ,rql.auction_header_id --Bug 4107528
322: FROM po_requisition_lines rql,
323: po_requisition_headers_all rqh, --
324: mtl_system_items_kfv msi
325: WHERE rql.requisition_header_id = rqh.requisition_header_id
326: and rql.requisition_line_id = v_document_id
327: AND rql.item_id = msi.inventory_item_id(+)

Line 565: po_requisition_headers_all rqh, --

561: resc.orig_need_by_date
562: ,rql.auction_header_id --Bug 4107528
563: FROM po_reschedule_interface resc,
564: po_requisition_lines rql,
565: po_requisition_headers_all rqh, --
566: mtl_system_items_kfv msi
567: WHERE resc.auction_display_number = v_negotiation_num
568: and resc.process_id = v_process_id
569: and resc.line_id = rql.requisition_line_id

Line 592: po_requisition_headers_all rqh, --

588: null,
589: null
590: ,rql.auction_header_id --Bug 4107528
591: FROM po_requisition_lines rql,
592: po_requisition_headers_all rqh, --
593: mtl_system_items_kfv msi
594: WHERE rql.requisition_header_id = rqh.requisition_header_id
595: and rql.requisition_header_id = v_document_id
596: and rql.auction_display_number = v_negotiation_num