[Home] [Help]
413: -- allocated
414: CURSOR unallocatedItems IS
415: SELECT distinct itm.line_number
416: FROM pon_auction_item_prices_all itm,
417: po_req_lines_in_pool_src_v prlv
418: WHERE itm.auction_header_id = p_auction_header_id AND
419: nvl(itm.line_origination_code, 'NONE') = 'REQUISITION' AND
420: nvl(itm.allocation_status, 'NO') <> 'ALLOCATED' AND
421: nvl(itm.award_status, 'NO') = 'COMPLETED' AND
566: -- rescheduling has rescheduled the req quantity to a value lower than
567: -- the alloc quantity
568: CURSOR reqRescheduledSingleSupplier IS
569: SELECT paa.orig_req_line_id, prlsv.requisition_quantity
570: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
571: pon_auction_item_prices_all paip
572: WHERE paa.allocated_qty > prlsv.requisition_quantity AND
573: paa.auction_header_id = p_auction_header_id AND
574: nvl(paa.split_req_line_id, -999)= -999 AND
585: -- which the req qty is lower than the allocated qty as a result
586: -- of mrp rescheduling
587: CURSOR reqRescheduledMultSupplier IS
588: SELECT paa.orig_req_line_id
589: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
590: pon_auction_item_prices_all paip
591: WHERE paa.auction_header_id = p_auction_header_id AND
592: nvl(paa.split_req_line_id, -999)= -999 AND
593: nvl(paa.allocated_qty,0) > 0 AND
1025:
1026: SELECT requisition_line_id, requisition_header_id, requisition_quantity
1027: BULK COLLECT INTO l_req_line_id_col, l_req_header_id_col,
1028: l_req_quantity_col
1029: FROM po_req_lines_in_pool_src_v
1030: WHERE auction_header_id = p_auctionID AND
1031: auction_line_number = p_line_number AND
1032: nvl(modified_by_agent_flag, 'N') <> 'Y'
1033: ORDER BY need_by_date ASC, creation_date ASC;