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_ATTR_MAPPING dependencies on PON_BID_HEADERS

Line 384: FROM PON_BID_HEADERS PON

380: , l_vendor_id
381: , l_vendor_site_id
382: , l_vendor_name
383: , l_evaluation_flag
384: FROM PON_BID_HEADERS PON
385: , HZ_PARTIES HZ1
386: , HZ_PARTIES HZ2
387: , AP_SUPPLIERS AP
388: WHERE PON.AUCTION_HEADER_ID = p_auction_header_id

Line 973: FROM pon_bid_headers bid

969: , item.category_id
970: , item.approval_status
971: , f.inventory_organization_id
972: , NVL(hl.inventory_organization_id, -1) ship_to_org_id
973: FROM pon_bid_headers bid
974: , pon_bid_item_prices item
975: , pon_auction_item_prices_all price
976: , financials_system_params_all f
977: , hr_locations_all hl

Line 1141: FROM PON_BID_HEADERS

1137: -- single row UDA, it will always be the supplier response's scores.
1138: CURSOR bids_cursor(p_header_id IN NUMBER)
1139: IS
1140: SELECT BID_NUMBER
1141: FROM PON_BID_HEADERS
1142: WHERE AUCTION_HEADER_ID = p_header_id
1143: AND BID_STATUS = 'ACTIVE'
1144: AND VENDOR_ID <> -1
1145: ORDER BY VENDOR_ID,

Line 1153: FROM PON_BID_HEADERS BID

1149: CURSOR auctions_cursor(p_v_id IN NUMBER)
1150: IS
1151: SELECT BID.AUCTION_HEADER_ID
1152: , BID.BID_NUMBER
1153: FROM PON_BID_HEADERS BID
1154: , PON_AUCTION_HEADERS_ALL AUCTION
1155: WHERE BID.VENDOR_ID = p_v_id
1156: AND BID.AUCTION_HEADER_ID = AUCTION.AUCTION_HEADER_ID
1157: AND AUCTION.AUCTION_STATUS = 'AUCTION_CLOSED'