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

Line 136: AND Nvl(shipment_number,-1) NOT IN(SELECT shipment_number FROM pon_auction_shipments_all

132: FROM pon_auc_price_breaks_interface
133: WHERE BATCH_ID =p_batch_Id
134: AND AUCTION_HEADER_ID = p_auction_header_id
135: AND auction_line_number = l_line_number
136: AND Nvl(shipment_number,-1) NOT IN(SELECT shipment_number FROM pon_auction_shipments_all
137: WHERE auction_header_id = p_auction_header_id
138: AND line_number = l_line_number );
139:
140:

Line 156: FROM pon_auction_shipments_all

152: WHEN c_interface_lines%NOTFOUND;
153: BEGIN
154:
155: SELECT Nvl(max(shipment_number),-1) INTO l_shipment_number
156: FROM pon_auction_shipments_all
157: WHERE auction_header_id = p_auction_header_id
158: AND line_number = c_interface_lines_rec.auction_line_number;
159:
160: OPEN c_interface_ship_count(c_interface_lines_rec.auction_line_number);

Line 215: MERGE INTO pon_auction_shipments_all sl

211:
212: update_shipment_number(p_batch_id, p_auction_header_id);
213:
214: -- Update lines table with values in the interface table
215: MERGE INTO pon_auction_shipments_all sl
216: USING
217: (SELECT
218: pasi.auction_header_id,
219: pasi.auction_line_number,

Line 1688: pon_auction_shipments_all pasa

1684: UNION
1685:
1686: (SELECT pasa1.auction_line_number
1687: FROM pon_auc_price_breaks_interface pasa1,
1688: pon_auction_shipments_all pasa
1689: WHERE pasa1.auction_header_id = p_auction_header_id
1690: and pasa.auction_header_id = p_auction_header_id
1691: AND pasa1.batch_id = p_batch_id
1692: AND pasa.line_number = pasa1.auction_line_number