APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on PO_REQUISITION_HEADERS_ALL

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 566: po_requisition_headers_all rqh, --

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

Line 593: po_requisition_headers_all rqh, --

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