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 3172: -- 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

3168: --Step 5 and 6 are only for price break.
3169: IF (p_shipment_type = g_shipment_type_pricebreak) THEN
3170:
3171: --5 Mark Supplier owned Price Break
3172: -- 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
3173: -- Notes, if need to use g_pb_optionals_updated flag to determine skipped line, move this part before determin_xml_skipped_line
3174: update
3175: pon_bid_shipments_int bsi
3176: set bsi.action= g_pb_optional_updated

Line 3184: pon_auction_shipments_all ash

3180: and bsi.auction_shipment_number is not null
3181: and exists(
3182: select 1
3183: from
3184: pon_auction_shipments_all ash
3185: where
3186: ash.auction_header_id = bsi.auction_header_id
3187: and ash.line_number = bsi.line_number
3188: and ash.shipment_number = bsi.auction_shipment_number