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 313: pon_auction_item_prices_all al

309: WHERE pbip.bid_number = p_bid_number
310: AND pbip.line_number IN
311: (SELECT al.parent_line_number
312: FROM pon_bid_item_prices bl,
313: pon_auction_item_prices_all al
314: WHERE bl.bid_number = p_bid_number
315: AND bl.auction_header_id = al.auction_header_id
316: AND bl.line_number = al.line_number
317: AND al.group_type = 'GROUP_LINE'

Line 708: pon_auction_item_prices_all paip

704: 0))), 0), 0), 0))) s_bidded_lines
705:
706: ----------------------------------------------------------------------------
707: FROM pon_bid_item_prices bl,
708: pon_auction_item_prices_all paip
709: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
710: ---------------------------------------------------------------
711: , pon_auction_headers_all paha,
712: pon_bid_headers pbh

Line 746: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

742: -- All lines in a GROUP must be bid on simultaneously
743: WHEN s_group_type = 'GROUP' AND
744: (SELECT decode(sum(decode(bl.has_bid_flag, 'Y', 1, 0)), 0, 'OK',
745: count(bl.bid_number), 'OK', 'N')
746: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
747: WHERE bl.bid_number = p_bid_number
748: AND al.auction_header_id = bl.auction_header_id
749: AND al.line_number = bl.line_number
750: AND al.auction_header_id = p_auc_header_id

Line 797: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

793:
794: -- If a lot has no bid, none of it's children can be bid on
795: WHEN s_group_type = 'LOT' AND s_has_bid_flag = 'N' AND EXISTS
796: (SELECT bl.bid_number
797: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
798: WHERE bl.bid_number = p_bid_number
799: AND al.auction_header_id = bl.auction_header_id
800: AND al.line_number = bl.line_number
801: AND al.auction_header_id = p_auc_header_id

Line 861: , pon_auction_item_prices_all al

857: to_number(null)) s_worksheet_sequence_number,
858: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
859: al.line_num_display s_clm_line_num_display
860: FROM pon_bid_item_prices bl
861: , pon_auction_item_prices_all al
862: , pon_bid_headers pbh
863: WHERE bl.bid_number = p_bid_number
864: AND al.auction_header_id = bl.auction_header_id
865: AND al.line_number = bl.line_number

Line 2155: FROM pon_auction_item_prices_all al

2151: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
2152: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2153: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2154: al.line_num_display s_clm_line_num_display
2155: FROM pon_auction_item_prices_all al
2156: , pon_bid_item_prices bl
2157: , pon_bid_headers pbh
2158: WHERE al.auction_header_id = p_auc_header_id
2159: AND bl.bid_number = p_bid_number

Line 3128: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,

3124: bh.number_price_decimals s_precision,
3125: al.line_num_display s_clm_line_num_display,
3126: nvl(bl.clm_cost_constraint,'X') s_clm_cost_constraint, -- CLM QA Bug : 9835426
3127: al.order_type_lookup_code s_order_type_lookup_code --For clm bug : 10136754
3128: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
3129: pon_bid_headers bh
3130: WHERE al.auction_header_id = p_auc_header_id
3131: AND bh.bid_number = p_bid_number
3132: AND bl.bid_number = p_bid_number

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

3454: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3455: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
3456: al.line_num_display s_clm_line_num_display,
3457: Nvl(al.clm_info_flag, 'N') s_clm_info_flag
3458: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3459: WHERE al.auction_header_id = p_auc_header_id
3460: AND bl.bid_number = p_bid_number
3461: AND pah.auction_header_id = p_auc_header_id
3462: AND al.line_number = bl.line_number

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

3794: FROM pon_bid_payments_shipments pbps
3795: WHERE pbps.auction_header_id = p_auc_header_id
3796: AND pbps.bid_number = p_bid_number
3797: AND pbps.bid_line_number = bl.line_number) s_sum_pymt_amt --bug 14657112
3798: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3799: WHERE al.auction_header_id = p_auc_header_id
3800: AND bl.bid_number = p_bid_number
3801: AND pah.auction_header_id = p_auc_header_id
3802: AND al.line_number = bl.line_number

Line 4138: , pon_auction_item_prices_all al

4134: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code,
4135: al.line_num_display s_clm_line_num_display
4136: FROM pon_bid_attribute_values ba
4137: , pon_auction_attributes aa
4138: , pon_auction_item_prices_all al
4139: , pon_bid_item_prices bl
4140: , pon_bid_headers pbh
4141: WHERE ba.bid_number = p_bid_number
4142: AND ba.line_number <> -1

Line 4495: , pon_auction_item_prices_all al

4491: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
4492: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name,
4493: al.line_num_display s_clm_line_num_display
4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al
4496: , pon_bid_item_prices bl
4497: , pon_price_element_types_tl pft
4498: , pon_bid_headers pbh
4499: WHERE bpf.bid_number = p_bid_number

Line 5628: , pon_auction_item_prices_all al

5624: ) s_entity_name,
5625: al.line_num_display s_clm_line_num_display
5626: FROM pon_bid_shipments bpb
5627: , pon_bid_item_prices bl
5628: , pon_auction_item_prices_all al
5629: , pon_bid_headers pbh
5630: WHERE bpb.bid_number = p_bid_number
5631: AND bl.bid_number = bpb.bid_number
5632: AND bl.line_number = bpb.line_number

Line 6484: pon_auction_item_prices_all al,

6480: ) s_entity_name,
6481: al.line_num_display s_clm_line_num_display
6482: FROM pon_bid_shipments bpb,
6483: pon_bid_item_prices bl,
6484: pon_auction_item_prices_all al,
6485: (SELECT MAX(shipments.max_quantity) max_quantity,
6486: shipments.bid_number,
6487: shipments.line_number
6488: FROM pon_bid_shipments shipments

Line 6554: , pon_auction_item_prices_all al

6550: g_exp_date,
6551: 'LINENUM',
6552: al.document_disp_line_number
6553: From pon_bid_item_prices bl
6554: , pon_auction_item_prices_all al
6555: , pon_bid_headers pbh
6556: where bl.bid_number = p_bid_number
6557: AND al.auction_header_id = bl.auction_header_id
6558: AND al.line_number = bl.line_number

Line 7007: , pon_auction_item_prices_all al

7003: ) s_entity_name,
7004: al.line_num_display s_clm_line_num_display
7005: FROM pon_bid_price_differentials bpd
7006: , pon_bid_item_prices bl
7007: , pon_auction_item_prices_all al
7008: , pon_price_differentials apd
7009: , pon_auction_shipments_all apb
7010: , po_price_diff_lookups_v pdl
7011: , pon_bid_headers pbh

Line 7105: PON_AUCTION_ITEM_PRICES_ALL pai

7101: pai.document_disp_line_number,
7102: 'PAYITEMNUM',
7103: pbps.payment_display_number
7104: FROM PON_BID_PAYMENTS_SHIPMENTS pbps,
7105: PON_AUCTION_ITEM_PRICES_ALL pai
7106: WHERE pbps.auction_header_id= pai.auction_header_id
7107: AND pbps.auction_header_id=p_auc_header_id
7108: AND pbps.bid_line_number = pai.line_number
7109: AND pbps.bid_number = p_bid_number

Line 7390: PON_AUCTION_ITEM_PRICES_ALL pai,

7386: pai.close_bidding_date,
7387: pbp.bid_payment_id,
7388: pbi.line_number bid_line_number
7389: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
7390: PON_AUCTION_ITEM_PRICES_ALL pai,
7391: PON_BID_ITEM_PRICES pbi
7392: WHERE pbp.auction_header_id = pai.auction_header_id
7393: AND pbp.auction_line_number = pai.line_number
7394: AND pbi.auction_header_id = pai.auction_header_id