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_AWARD_PKG dependencies on PON_AUCTION_EXHIBIT_DETAILS

Line 1140: from pon_auction_exhibit_details paed,

1136:
1137: IS
1138: Cursor exhibitsCursor Is
1139: select paip.line_number
1140: from pon_auction_exhibit_details paed,
1141: pon_auction_item_prices_all paip
1142: where paed.auction_header_id = p_auction_header_id
1143: and paed.associated_to_line = p_line_num
1144: AND paip.auction_header_id = paed.auction_header_id

Line 1246: pon_auction_exhibit_details paed,

1242: -- This sql gets parent line for an elin. Also whether parent is clin/slin.
1243: SELECT paed.associated_to_line, Decode(Nvl(paip_parent.group_line_id, -1), -1, 'N', 'Y')
1244: INTO l_parent_line, is_parent_slin
1245: FROM pon_auction_item_prices_all paip_elin,
1246: pon_auction_exhibit_details paed,
1247: pon_auction_item_prices_all paip_parent
1248: WHERE paip_elin.auction_header_id = p_auction_header_id
1249: AND paip_elin.line_number = p_line_num
1250: AND paed.auction_header_id = paip_elin.auction_header_id

Line 2149: FROM pon_auction_exhibit_details exhibit,

2145:
2146: --This cursor gets all the elins associated to particular line.
2147: CURSOR get_elins_for_line IS
2148: SELECT paip.line_number
2149: FROM pon_auction_exhibit_details exhibit,
2150: pon_auction_item_prices_all paip,
2151: pon_bid_item_prices pbip
2152: WHERE exhibit.auction_header_id = p_auction_id
2153: AND exhibit.associated_to_line = p_line_number