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_AUCTION_SHIPMENTS_ALL

Line 2959: -- 5.1 Mark Supplier owned Price Break set auction_shipment_number="" and has_price_differentials_flag='N' by comparing the 5 columns in PON_BID_SHIPMENTS with PON_AUCTION_SHIPMENTS_ALL

2955: --Step 5 and 6 are only for price break.
2956: IF (p_shipment_type = g_shipment_type_pricebreak) THEN
2957:
2958: --5 Mark Supplier owned Price Break
2959: -- 5.1 Mark Supplier owned Price Break set auction_shipment_number="" and has_price_differentials_flag='N' by comparing the 5 columns in PON_BID_SHIPMENTS with PON_AUCTION_SHIPMENTS_ALL
2960: -- Notes, if need to use g_pb_optionals_updated flag to determine skipped line, move this part before determin_xml_skipped_line
2961: update
2962: pon_bid_shipments_int bsi
2963: set bsi.action= g_pb_optional_updated

Line 2971: pon_auction_shipments_all ash

2967: and bsi.auction_shipment_number is not null
2968: and exists(
2969: select 1
2970: from
2971: pon_auction_shipments_all ash
2972: where
2973: ash.auction_header_id = bsi.auction_header_id
2974: and ash.line_number = bsi.line_number
2975: and ash.shipment_number = bsi.auction_shipment_number