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_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 818: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,

814: UPDATE pon_bid_price_differ_int bpdi
815: SET bpdi.sequence_number =
816: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
817: g_skip_int, bpd.price_differential_number)
818: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,
819: pon_auction_item_prices_all al
820: WHERE pdl.price_differential_dsp = bpdi.price_type
821: AND bpd.bid_number = bpdi.bid_number
822: AND bpd.line_number = bpdi.auction_line_number

Line 1154: MERGE INTO pon_bid_price_differentials bpd

1150: IF (p_blanket = 'Y') THEN
1151:
1152: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1153: -- Copy over all Line level price differentials to transaction table
1154: MERGE INTO pon_bid_price_differentials bpd
1155: USING
1156: (SELECT
1157: bid_number,
1158: auction_line_number,

Line 1181: MERGE INTO pon_bid_price_differentials bpd

1177: --copy over price break level price differentials to transaction table
1178: --only copy when this is price break
1179: IF (p_price_tiers_indicator = g_pt_indicator_pricebreak) THEN
1180:
1181: MERGE INTO pon_bid_price_differentials bpd
1182: USING
1183: ( select bpdi.bid_number,
1184: bpdi.auction_line_number,
1185: bsh.shipment_number,

Line 1223: MERGE INTO pon_bid_price_differentials bpd

1219: p_shipment_type => g_shipment_type_pricebreak
1220: );
1221: END IF;-- end of IF (p_price_tiers_indicator = g_pt_indicator_pricebreak)
1222: ELSE
1223: MERGE INTO pon_bid_price_differentials bpd
1224: USING
1225: (SELECT
1226: bid_number,
1227: auction_line_number,

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

3004: and bshi.line_number = bsh.line_number
3005: and bshi.bid_shipment_number = bsh.shipment_number );
3006:
3007: --6. Remove Price Differentials from transaction table
3008: --Remove Price Differentials from PON_BID_PRICE_DIFFERENTIALS which associated supplier owned Price Break
3009: -- and deleted Price Break.
3010: delete from pon_bid_price_differentials bsd
3011: where
3012: bsd.shipment_number<>-1

Line 3010: delete from pon_bid_price_differentials bsd

3006:
3007: --6. Remove Price Differentials from transaction table
3008: --Remove Price Differentials from PON_BID_PRICE_DIFFERENTIALS which associated supplier owned Price Break
3009: -- and deleted Price Break.
3010: delete from pon_bid_price_differentials bsd
3011: where
3012: bsd.shipment_number<>-1
3013: and bsd.bid_number=p_bid_number
3014: and bsd.line_number in