eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_BACKING_REQUISITIONS

Line 5721: FROM pon_bid_backing_requisitions

5717:
5718: BEGIN
5719: --API call TO populate fund allocations to PON_AWARD_ALLOCATIONS table
5720: SELECT 'Y' INTO l_linked_pr_line_exists
5721: FROM pon_bid_backing_requisitions
5722: WHERE auction_header_id = p_auction_header_id
5723: AND ROWNUM <2;
5724:
5725: EXCEPTION

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 6122: FROM pon_bid_backing_requisitions pbr

6118: AND pir.link_done_by = 'BOTH'
6119: union
6120: SELECT pbr.auction_header_id, pbr.auction_line_number, pbr.bid_number, pbr.bid_line_number,
6121: pbr.requisition_line_id , pbr.requisition_header_id
6122: FROM pon_bid_backing_requisitions pbr
6123: WHERE pbr.auction_header_id = p_auction_header_id) pbrv,
6124:
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,

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

Line 6140: FROM pon_bid_backing_requisitions pbr

6136: AND pir.link_done_by = 'BOTH'
6137: union
6138: SELECT pbr.auction_header_id, pbr.auction_line_number, pbr.bid_number, pbr.bid_line_number,
6139: pbr.requisition_line_id , pbr.requisition_header_id
6140: FROM pon_bid_backing_requisitions pbr
6141: WHERE pbr.auction_header_id = p_auction_header_id ) pbrv1
6142: WHERE pbip.auction_header_id = p_auction_header_id
6143: AND pbip.auction_header_id = pbrv1.auction_header_id
6144: AND pbip.auction_line_number = pbrv1.auction_line_number