[Home] [Help]
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,
13: need_by_date po_requisition_lines.need_by_date%TYPE,
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
299: AND rql.at_sourcing_flag = 'Y' --
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(+)
328: AND nvl(msi.organization_id, rql.destination_organization_id) =
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
570: and rql.requisition_header_id = rqh.requisition_header_id
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
597: AND at_sourcing_flag = 'Y' --