DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_ITEM_REFERENCES

Line 6112: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1

6108: pon_bid_headers pbh,
6109: po_clmreq_lines_v prl,
6110: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6111: pbr.requisition_line_id, pbr.requisition_header_id
6112: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1
6113: WHERE pir.auction_header_id = p_auction_header_id
6114: AND pir.auction_header_id = pbr.auction_header_id
6115: AND pir.auction_line_number = pbr.auction_line_number
6116: AND pir.bid_number = pbip1.bid_number

Line 6129: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1

6125: (SELECT pbrv1.requisition_line_id, sum (pbip.award_quantity * pbip.award_price) AS tot_bid_line_amount
6126: FROM pon_bid_item_prices pbip,
6127: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6128: pbr.requisition_line_id, pbr.requisition_header_id
6129: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1
6130: WHERE pir.auction_header_id = p_auction_header_id
6131:
6132: AND pir.auction_header_id = pbr.auction_header_id
6133: AND pir.auction_line_number = pbr.auction_line_number