[Home] [Help]
669: , bh.bid_status AS s_bid_status
670: , pv.end_date_active AS s_end_date_active
671: , ap.award_shipment_number as s_award_shipment_number
672: FROM pon_award_items_interface ap
673: , pon_auction_item_prices_all ai
674: , pon_bid_headers bh
675: , po_vendors pv
676: WHERE ap.batch_id = p_batch_id
677: AND ap.auction_header_id = ai.auction_header_id
722: , l_login_id
723: , 'LINE_NUMBER'
724: , ai.document_disp_line_number
725: FROM PON_AWARD_ITEMS_INTERFACE paii,
726: pon_auction_item_prices_all ai,
727: pon_auction_headers_all ah,
728: po_line_types_tl pltt
729: WHERE paii.batch_id = p_batch_id
730: AND paii.award_status = 'Y'
1615:
1616: -- maximum allowed clin number is 9999
1617: -- so we wont accept more than 9999 clins
1618: IF(l_is_fed = 'Y') THEN
1619: SELECT Count(*) INTO l_sol_line_count FROM pon_auction_item_prices_all
1620: WHERE auction_header_id = l_auction_header_id
1621: AND group_line_id IS NULL;
1622:
1623: SELECT Count(*) INTO l_int_line_count FROM pon_item_prices_interface
3893: batch_id,
3894: interface_line_id
3895: from pon_item_prices_interface p1
3896: where price_break_type = 'NONE'
3897: AND Nvl((SELECT has_shipments_flag FROM pon_auction_item_prices_all WHERE line_number = p1.auction_line_number AND auction_header_id = l_auction_header_id),'N') = 'Y'
3898: AND ORDER_TYPE_LOOKUP_CODE NOT IN( 'AMOUNT','FIXED PRICE')
3899: AND Nvl(clm_info_flag,'N') <> 'Y'
3900: AND group_type <> 'GROUP'
3901: AND batch_id = p_batch_id;