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_OPT_PKG dependencies on PON_BID_SHIPMENTS

Line 50: from pon_optimize_results por,pon_bid_shipments pbs,

46: sysdate AS LAST_UPDATE_DATE,
47: por.LAST_UPDATED_BY,
48: por.LAST_UPDATE_LOGIN,
49: pbip.FIXED_AMOUNT_COMPONENT AS FIXED_AMOUNT_COMPONENT
50: from pon_optimize_results por,pon_bid_shipments pbs,
51: pon_bid_item_prices pbip
52: where por.scenario_id =p_scenario_id
53: and pbs.bid_number = por.bid_number
54: and pbs.line_number = por.line_number

Line 127: from pon_bid_shipments

123: BEGIN
124: print_log(' Trying Exact Match l_new_shipment_number');
125: select shipment_number,per_unit_price_component
126: into l_new_shipment_number,l_per_unit_price_component
127: from pon_bid_shipments
128: where quantity <= l_total_award_quantity
129: and max_quantity >= l_total_award_quantity
130: and bid_number = l_prob_lines(l_index).bid_number
131: and line_number = l_prob_lines(l_index).line_number;

Line 145: from pon_bid_shipments pbs1

141: select max_quantity,shipment_number,
142: per_unit_price_component
143: into l_new_total_award_quantity,l_new_shipment_number,
144: l_per_unit_price_component
145: from pon_bid_shipments pbs1
146: where pbs1.max_quantity =
147: (SELECT MAX(max_quantity)
148: FROM pon_bid_shipments pbs2
149: WHERE pbs2.max_quantity < l_total_award_quantity

Line 148: FROM pon_bid_shipments pbs2

144: l_per_unit_price_component
145: from pon_bid_shipments pbs1
146: where pbs1.max_quantity =
147: (SELECT MAX(max_quantity)
148: FROM pon_bid_shipments pbs2
149: WHERE pbs2.max_quantity < l_total_award_quantity
150: and pbs2.bid_number = l_prob_lines(l_index).bid_number
151: and pbs2.line_number = l_prob_lines(l_index).line_number)
152: and pbs1.bid_number = l_prob_lines(l_index).bid_number

Line 224: from pon_optimize_results por,pon_bid_shipments pbs

220:
221: select sum(por.AWARD_QUANTITY * por.award_price) as scenario_total,
222: sum(por.award_quantity*nvl2(por.award_shipment_number,pbs.unit_price,pbip.unit_price)) as po_total
223: into l_po_total,l_scenario_total
224: from pon_optimize_results por,pon_bid_shipments pbs
225: ,pon_bid_item_prices pbip
226: where por.scenario_id = p_scenario_id
227: and pbs.bid_number(+) = por.bid_number
228: and pbs.line_number(+) = por.line_number