APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_REQ_LINES_IN_POOL_SRC_V

Line 391: po_req_lines_in_pool_src_v prlv

387: -- allocated
388: CURSOR unallocatedItems IS
389: SELECT distinct itm.line_number
390: FROM pon_auction_item_prices_all itm,
391: po_req_lines_in_pool_src_v prlv
392: WHERE itm.auction_header_id = p_auction_header_id AND
393: nvl(itm.line_origination_code, 'NONE') = 'REQUISITION' AND
394: nvl(itm.allocation_status, 'NO') <> 'ALLOCATED' AND
395: nvl(itm.award_status, 'NO') = 'COMPLETED' AND

Line 544: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,

540: -- rescheduling has rescheduled the req quantity to a value lower than
541: -- the alloc quantity
542: CURSOR reqRescheduledSingleSupplier IS
543: SELECT paa.orig_req_line_id, prlsv.requisition_quantity
544: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
545: pon_auction_item_prices_all paip
546: WHERE paa.allocated_qty > prlsv.requisition_quantity AND
547: paa.auction_header_id = p_auction_header_id AND
548: nvl(paa.split_req_line_id, -999)= -999 AND

Line 563: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,

559: -- which the req qty is lower than the allocated qty as a result
560: -- of mrp rescheduling
561: CURSOR reqRescheduledMultSupplier IS
562: SELECT paa.orig_req_line_id
563: FROM pon_award_allocations paa, po_req_lines_in_pool_src_v prlsv,
564: pon_auction_item_prices_all paip
565: WHERE paa.auction_header_id = p_auction_header_id AND
566: nvl(paa.split_req_line_id, -999)= -999 AND
567: nvl(paa.allocated_qty,0) > 0 AND

Line 971: FROM po_req_lines_in_pool_src_v

967:
968: SELECT requisition_line_id, requisition_header_id, requisition_quantity
969: BULK COLLECT INTO l_req_line_id_col, l_req_header_id_col,
970: l_req_quantity_col
971: FROM po_req_lines_in_pool_src_v
972: WHERE auction_header_id = p_auctionID AND
973: auction_line_number = p_line_number AND
974: nvl(modified_by_agent_flag, 'N') <> 'Y'
975: ORDER BY need_by_date ASC, creation_date ASC;