APPS.PON_VALIDATE_SHIPMENTS_INT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 77: FROM pon_auction_item_prices_all

73: IF(l_is_fed = 'Y') THEN
74: UPDATE pon_auc_price_breaks_interface pb_int
75: SET auction_line_number =
76: (SELECT line_number
77: FROM pon_auction_item_prices_all
78: WHERE LINE_NUM_DISPLAY = pb_int.DOCUMENT_DISP_LINE_NUMBER
79: AND auction_header_id = p_auction_header_id
80: )
81: WHERE batch_id = p_batch_id;

Line 87: FROM pon_auction_item_prices_all

83: ELSE
84: UPDATE pon_auc_price_breaks_interface pb_int
85: SET auction_line_number =
86: (SELECT line_number
87: FROM pon_auction_item_prices_all
88: WHERE DOCUMENT_DISP_LINE_NUMBER = pb_int.DOCUMENT_DISP_LINE_NUMBER
89: AND auction_header_id = p_auction_header_id
90: )
91: WHERE batch_id = p_batch_id;

Line 237: pon_auction_item_prices_all paip,

233: pasi.effective_end_date,
234: paip.price_break_type,
235: pah.price_tiers_indicator
236: FROM pon_auc_price_breaks_interface pasi,
237: pon_auction_item_prices_all paip,
238: pon_auction_headers_all pah
239: WHERE pasi.batch_id = p_batch_id
240: AND pasi.auction_header_id = p_auction_header_id
241: AND pasi.auction_header_id = paip.auction_header_id

Line 312: UPDATE pon_auction_item_prices_all

308: END if;
309:
310:
311: -- Update lines table
312: UPDATE pon_auction_item_prices_all
313: SET has_shipments_flag= 'Y'
314: WHERE auction_header_id= p_auction_header_id
315: AND line_number IN(SELECT line_number FROM pon_auc_price_breaks_interface
316: WHERE batch_id = p_batch_id

Line 1278: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,

1274: paha.global_agreement_flag sel_global_agreement_flag,
1275: papbi.ship_to_organization sel_ship_to_organization,
1276: papbi.ship_to_location sel_ship_to_location,
1277: paha.close_bidding_date sel_close_bidding_date
1278: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
1279: pon_auc_price_breaks_interface papbi,
1280: pon_auction_headers_all paha
1281: WHERE PAIP.AUCTION_HEADER_ID(+) = p_auction_header_id
1282: AND papbi.AUCTION_HEADER_ID = p_auction_header_id

Line 1627: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,

1623: paip.order_type_lookup_code sel_order_type_lookup_code,
1624: paip.PURCHASE_BASIS sel_PURCHASE_BASIS,
1625: paip.clm_info_flag sel_clm_info_flag,
1626: paha.close_bidding_date sel_close_bidding_date
1627: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
1628: pon_auc_price_breaks_interface papbi,
1629: pon_auction_headers_all paha
1630: WHERE PAIP.AUCTION_HEADER_ID(+) = p_auction_header_id
1631: AND papbi.AUCTION_HEADER_ID = p_auction_header_id