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_CONSOLE_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 1038: FROM pon_auction_item_prices_all al

1034: SELECT 'N'
1035: INTO x_est_qty_available_flag
1036: FROM dual
1037: WHERE EXISTS (SELECT 1
1038: FROM pon_auction_item_prices_all al
1039: WHERE al.auction_header_id = p_auction_header_id
1040: AND al.group_type NOT IN ('GROUP','LOT_LINE')
1041: AND al.order_type_lookup_code <> 'FIXED PRICE'
1042: AND NVL(quantity, 0) = 0);

Line 1048: FROM pon_auction_item_prices_all al

1044: SELECT 'N'
1045: INTO x_est_qty_available_flag
1046: FROM dual
1047: WHERE EXISTS (SELECT 1
1048: FROM pon_auction_item_prices_all al
1049: WHERE al.auction_header_id = p_auction_header_id
1050: AND al.line_number = p_auction_line_number
1051: AND al.group_type NOT IN ('GROUP','LOT_LINE')
1052: AND al.order_type_lookup_code <> 'FIXED PRICE'

Line 1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;

1455:
1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;
1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;
1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;
1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;
1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;
1461:
1462: l_line_number_tbl line_number_tbl_type;
1463: l_bid_price_tbl bid_price_tbl_type;

Line 1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;

1456: TYPE line_number_tbl_type IS TABLE OF pon_bid_item_prices.line_number%TYPE;
1457: TYPE bid_price_tbl_type IS TABLE OF pon_bid_item_prices.price%TYPE;
1458: TYPE bid_qty_tbl_type IS TABLE OF pon_bid_item_prices.quantity%TYPE;
1459: TYPE current_price_tbl_type IS TABLE OF pon_auction_item_prices_all.current_price%TYPE;
1460: TYPE auction_qty_tbl_type IS TABLE OF pon_auction_item_prices_all.quantity%TYPE;
1461:
1462: l_line_number_tbl line_number_tbl_type;
1463: l_bid_price_tbl bid_price_tbl_type;
1464: l_bid_qty_tbl bid_qty_tbl_type;

Line 1487: FROM PON_AUCTION_ITEM_PRICES_ALL

1483: (nvl(current_price, 0) * decode(order_type_lookup_code, 'FIXED PRICE', 1, quantity)),0)) NO_BID_VALUE
1484: INTO l_auction_value,
1485: l_no_bid_lines,
1486: l_no_bid_value
1487: FROM PON_AUCTION_ITEM_PRICES_ALL
1488: WHERE group_type in ('LOT', 'LINE', 'GROUP_LINE')
1489: AND auction_header_id = P_AUCTION_ID;
1490: EXCEPTION
1491: WHEN NO_DATA_FOUND THEN

Line 1517: pon_auction_item_prices_all ai

1513: BULK COLLECT INTO l_line_number_tbl, l_bid_price_tbl, l_bid_qty_tbl, l_current_price_tbl, l_auction_qty_tbl
1514: FROM pon_bid_headers bh,
1515: pon_bid_item_prices bl,
1516: pon_auction_headers_all ah,
1517: pon_auction_item_prices_all ai
1518: WHERE ah.auction_header_id = bh.auction_header_id
1519: and bh.auction_header_id = bl.auction_header_id
1520: and bh.bid_number = bl.bid_number
1521: and bh.bid_status = 'ACTIVE'