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_SOURCING_OPENAPI_GRP dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 1241: INSERT INTO pon_auction_shipments_all

1237: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1238: ' copying price breaks and price break level price differentials' );
1239: end if;
1240:
1241: INSERT INTO pon_auction_shipments_all
1242: (auction_header_id,
1243: line_number,
1244: shipment_number,
1245: shipment_type,

Line 1284: UPDATE pon_auction_shipments_all

1280: GROUP BY interface_line_number,ship_to_organization_id, ship_to_location_id, quantity;
1281:
1282: -- ADDED FOR SERVICES PROCUREMENT PROJECT
1283: -- Update the price differntials flag based on if their are price differentials at shipments level
1284: UPDATE pon_auction_shipments_all
1285: SET has_price_differentials_flag = 'Y',
1286: differential_response_type = 'OPTIONAL'
1287: WHERE (shipment_number) IN
1288: (SELECT interface_shipment_number