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

Line 300: pon_auction_item_prices_all al

296: WHERE pbip.bid_number = p_bid_number
297: AND pbip.line_number IN
298: (SELECT al.parent_line_number
299: FROM pon_bid_item_prices bl,
300: pon_auction_item_prices_all al
301: WHERE bl.bid_number = p_bid_number
302: AND bl.auction_header_id = al.auction_header_id
303: AND bl.line_number = al.line_number
304: AND al.group_type = 'GROUP_LINE'

Line 642: pon_auction_item_prices_all paip

638: decode(NVL(paha.TECHNICAL_EVALUATION_STATUS, 'NOT_COMPLETED'), 'NOT_COMPLETED',
639: decode(NVL(pbh.surrog_bid_flag, 'N'), 'Y', 1, 0), 0), 0), 0))) s_bidded_lines
640: ----------------------------------------------------------------------------
641: FROM pon_bid_item_prices bl,
642: pon_auction_item_prices_all paip
643: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
644: ---------------------------------------------------------------
645: , pon_auction_headers_all paha,
646: pon_bid_headers pbh

Line 678: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

674: -- All lines in a GROUP must be bid on simultaneously
675: WHEN s_group_type = 'GROUP' AND
676: (SELECT decode(sum(decode(bl.has_bid_flag, 'Y', 1, 0)), 0, 'OK',
677: count(bl.bid_number), 'OK', 'N')
678: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
679: WHERE bl.bid_number = p_bid_number
680: AND al.auction_header_id = bl.auction_header_id
681: AND al.line_number = bl.line_number
682: AND al.auction_header_id = p_auc_header_id

Line 728: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

724:
725: -- If a lot has no bid, none of it's children can be bid on
726: WHEN s_group_type = 'LOT' AND s_has_bid_flag = 'N' AND EXISTS
727: (SELECT bl.bid_number
728: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
729: WHERE bl.bid_number = p_bid_number
730: AND al.auction_header_id = bl.auction_header_id
731: AND al.line_number = bl.line_number
732: AND al.auction_header_id = p_auc_header_id

Line 790: , pon_auction_item_prices_all al

786: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number,
787: to_number(null)) s_worksheet_sequence_number,
788: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
789: FROM pon_bid_item_prices bl
790: , pon_auction_item_prices_all al
791: , pon_bid_headers pbh
792: WHERE bl.bid_number = p_bid_number
793: AND al.auction_header_id = bl.auction_header_id
794: AND al.line_number = bl.line_number

Line 1600: FROM pon_auction_item_prices_all al

1596: al.document_disp_line_number s_document_disp_line_number,
1597: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
1598: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
1599: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
1600: FROM pon_auction_item_prices_all al
1601: , pon_bid_item_prices bl
1602: , pon_bid_headers pbh
1603: WHERE al.auction_header_id = p_auc_header_id
1604: AND bl.bid_number = p_bid_number

Line 2476: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,

2472: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2473: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2474: bh.rate s_rate,
2475: bh.number_price_decimals s_precision
2476: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
2477: pon_bid_headers bh
2478: WHERE al.auction_header_id = p_auc_header_id
2479: AND bh.bid_number = p_bid_number
2480: AND bl.bid_number = p_bid_number

Line 2788: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

2784: pah.contract_type,
2785: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
2786: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2787: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
2788: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
2789: WHERE al.auction_header_id = p_auc_header_id
2790: AND bl.bid_number = p_bid_number
2791: AND pah.auction_header_id = p_auc_header_id
2792: AND al.line_number = bl.line_number

Line 3111: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

3107: pah.contract_type,
3108: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
3109: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3110: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
3111: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3112: WHERE al.auction_header_id = p_auc_header_id
3113: AND bl.bid_number = p_bid_number
3114: AND pah.auction_header_id = p_auc_header_id
3115: AND al.line_number = bl.line_number

Line 3436: , pon_auction_item_prices_all al

3432: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, null) s_worksheet_sequence_number,
3433: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code
3434: FROM pon_bid_attribute_values ba
3435: , pon_auction_attributes aa
3436: , pon_auction_item_prices_all al
3437: , pon_bid_item_prices bl
3438: , pon_bid_headers pbh
3439: WHERE ba.bid_number = p_bid_number
3440: AND ba.line_number <> -1

Line 3787: , pon_auction_item_prices_all al

3783: decode(p_spreadsheet, g_xml_upload_mode,
3784: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
3785: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name
3786: FROM pon_bid_price_elements bpf
3787: , pon_auction_item_prices_all al
3788: , pon_bid_item_prices bl
3789: , pon_price_element_types_tl pft
3790: , pon_bid_headers pbh
3791: WHERE bpf.bid_number = p_bid_number

Line 4900: , pon_auction_item_prices_all al

4896: null
4897: ) s_entity_name
4898: FROM pon_bid_shipments bpb
4899: , pon_bid_item_prices bl
4900: , pon_auction_item_prices_all al
4901: , pon_bid_headers pbh
4902: WHERE bpb.bid_number = p_bid_number
4903: AND bl.bid_number = bpb.bid_number
4904: AND bl.line_number = bpb.line_number

Line 5743: pon_auction_item_prices_all al,

5739: null
5740: ) s_entity_name
5741: FROM pon_bid_shipments bpb,
5742: pon_bid_item_prices bl,
5743: pon_auction_item_prices_all al,
5744: (SELECT MAX(shipments.max_quantity) max_quantity,
5745: shipments.bid_number,
5746: shipments.line_number
5747: FROM pon_bid_shipments shipments

Line 5813: , pon_auction_item_prices_all al

5809: g_exp_date,
5810: 'LINENUM',
5811: al.document_disp_line_number
5812: From pon_bid_item_prices bl
5813: , pon_auction_item_prices_all al
5814: , pon_bid_headers pbh
5815: where bl.bid_number = p_bid_number
5816: AND al.auction_header_id = bl.auction_header_id
5817: AND al.line_number = bl.line_number

Line 6259: , pon_auction_item_prices_all al

6255: null
6256: ) s_entity_name
6257: FROM pon_bid_price_differentials bpd
6258: , pon_bid_item_prices bl
6259: , pon_auction_item_prices_all al
6260: , pon_price_differentials apd
6261: , pon_auction_shipments_all apb
6262: , po_price_diff_lookups_v pdl
6263: , pon_bid_headers pbh

Line 6357: PON_AUCTION_ITEM_PRICES_ALL pai

6353: pai.document_disp_line_number,
6354: 'PAYITEMNUM',
6355: pbps.payment_display_number
6356: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,
6357: PON_AUCTION_ITEM_PRICES_ALL pai
6358: WHERE pbps.auction_header_id= pai.auction_header_id
6359: AND pbps.auction_header_id=p_auc_header_id
6360: AND pbps.bid_line_number = pai.line_number
6361: AND pbps.bid_number = p_bid_number

Line 6642: PON_AUCTION_ITEM_PRICES_ALL pai,

6638: pai.close_bidding_date,
6639: pbp.bid_payment_id,
6640: pbi.line_number bid_line_number
6641: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
6642: PON_AUCTION_ITEM_PRICES_ALL pai,
6643: PON_BID_ITEM_PRICES pbi
6644: WHERE pbp.auction_header_id = pai.auction_header_id
6645: AND pbp.auction_line_number = pai.line_number
6646: AND pbi.auction_header_id = pai.auction_header_id