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.

[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 895: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,

891: UPDATE pon_bid_price_differ_int bpdi
892: SET bpdi.sequence_number =
893: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
894: g_skip_int, bpd.price_differential_number)
895: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,
896: pon_auction_item_prices_all al
897: WHERE pdl.price_differential_dsp = bpdi.price_type
898: AND bpd.bid_number = bpdi.bid_number
899: AND bpd.line_number = bpdi.auction_line_number

Line 1353: MERGE INTO pon_bid_price_differentials bpd

1349: IF (p_blanket = 'Y') THEN
1350:
1351: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1352: -- Copy over all Line level price differentials to transaction table
1353: MERGE INTO pon_bid_price_differentials bpd
1354: USING
1355: (SELECT
1356: bid_number,
1357: auction_line_number,

Line 1380: MERGE INTO pon_bid_price_differentials bpd

1376: --copy over price break level price differentials to transaction table
1377: --only copy when this is price break
1378: IF (p_price_tiers_indicator = g_pt_indicator_pricebreak) THEN
1379:
1380: MERGE INTO pon_bid_price_differentials bpd
1381: USING
1382: ( select bpdi.bid_number,
1383: bpdi.auction_line_number,
1384: bsh.shipment_number,

Line 1422: MERGE INTO pon_bid_price_differentials bpd

1418: p_shipment_type => g_shipment_type_pricebreak
1419: );
1420: END IF;-- end of IF (p_price_tiers_indicator = g_pt_indicator_pricebreak)
1421: ELSE
1422: MERGE INTO pon_bid_price_differentials bpd
1423: USING
1424: (SELECT
1425: bid_number,
1426: auction_line_number,

Line 3221: --Remove Price Differentials from PON_BID_PRICE_DIFFERENTIALS which associated supplier owned Price Break

3217: and bshi.line_number = bsh.line_number
3218: and bshi.bid_shipment_number = bsh.shipment_number );
3219:
3220: --6. Remove Price Differentials from transaction table
3221: --Remove Price Differentials from PON_BID_PRICE_DIFFERENTIALS which associated supplier owned Price Break
3222: -- and deleted Price Break.
3223: delete from pon_bid_price_differentials bsd
3224: where
3225: bsd.shipment_number<>-1

Line 3223: delete from pon_bid_price_differentials bsd

3219:
3220: --6. Remove Price Differentials from transaction table
3221: --Remove Price Differentials from PON_BID_PRICE_DIFFERENTIALS which associated supplier owned Price Break
3222: -- and deleted Price Break.
3223: delete from pon_bid_price_differentials bsd
3224: where
3225: bsd.shipment_number<>-1
3226: and bsd.bid_number=p_bid_number
3227: and bsd.line_number in