[Home] [Help]
201: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
202: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
203: nvl(pbip.bid_currency_price,0)) bid_total
204: INTO v_bid_total
205: FROM pon_bid_item_prices pbip,
206: pon_auction_item_prices_all paip
207: WHERE pbip.auction_header_id = p_auction_header_id AND
208: pbip.bid_number = p_bid_number AND
209: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
2846: ,pa_tasks_expend_v task
2847: ,gms_awards_all awrd
2848: ,hr_all_organization_units hrorg
2849: ,fnd_user fuser
2850: ,pon_bid_item_prices pbip
2851: where
2852: paip.auction_header_id = p_auction_header_id
2853: AND paip.line_number = line_num
2854: and pbip.auction_header_id(+) = paip.auction_header_id
2979: AND lkp1.lookup_type(+) = 'PAYMENT TYPE'
2980: AND pay.uom_code = uom_tl.uom_code(+)
2981: AND uom_tl.language(+) = l_printing_language
2982: AND fuser.user_id(+) = pay.work_approver_user_id
2983: AND not exists (select 1 from pon_bid_item_prices where bid_number = p_bid_number and line_number=pay.line_number)
2984: UNION ALL
2985: SELECT
2986: pbp.BID_PAYMENT_ID payment_id
2987: ,pbp.payment_display_number payment_display_number
3041: po_lookup_codes lkp1,
3042: fnd_territories_tl terr,
3043: mtl_units_of_measure_tl uom_tl,
3044: pon_bid_payments_shipments pbp,
3045: pon_bid_item_prices pbip
3046: WHERE
3047: pbp.bid_number = p_bid_number
3048: AND pbp.auction_line_number = line_num
3049: AND pbp.auction_header_id = pay.auction_header_id(+)
3332: AND paip.line_number = pbsm.line_number
3333: AND pbsm.shipment_type = 'PRICE BREAK'
3334: AND mp.organization_id(+) = pbsm.ship_to_organization_id
3335: AND loc.location_id(+) = pbsm.ship_to_location_id
3336: and exists (select 1 from pon_bid_item_prices where bid_number=pbsm.bid_number and line_number=pbsm.line_number)
3337:
3338: UNION ALL
3339:
3340: SELECT pas.shipment_number,
3368: AND paip.line_number = pas.line_number
3369: AND pas.shipment_type = 'PRICE BREAK'
3370: AND mp.organization_id(+) = pas.ship_to_organization_id
3371: AND loc.location_id(+) = pas.ship_to_location_id
3372: and not exists (select 1 from pon_bid_item_prices where bid_number=p_bid_number and line_number=paip.line_number);
3373:
3374: BEGIN
3375: itempbreaksCtx := DBMS_XMLGEN.newContext(item_pb_cursor);
3376: DBMS_XMLGEN.SetRowSetTag(itempbreaksCtx, 'ITEM_PRICE_BREAKS');
3447: and pbsm.auction_shipment_number = pas.shipment_number(+)
3448: AND paip.auction_header_id = pbsm.auction_header_id
3449: AND paip.line_number = pbsm.line_number
3450: AND pbsm.shipment_type = 'QUANTITY BASED'
3451: and exists (select 1 from pon_bid_item_prices where bid_number=pbsm.bid_number and line_number=pbsm.line_number)
3452:
3453: UNION ALL
3454:
3455: SELECT pas.shipment_number,
3468: AND pas.line_number = line_num
3469: AND paip.auction_header_id = pas.auction_header_id
3470: AND paip.line_number = pas.line_number
3471: AND pas.shipment_type = 'QUANTITY BASED'
3472: and not exists (select 1 from pon_bid_item_prices where bid_number=p_bid_number and line_number=paip.line_number)
3473: ORDER BY bid_shipment_number ASC;
3474:
3475: BEGIN
3476: quanTiersCtx := DBMS_XMLGEN.newContext(item_quan_cursor);
4291: AND
4292: pbhs.auction_header_id (+) = p_auction_header_id
4293: and pbhs.bid_number (+) = p_bid_number
4294: AND ad.entity_name IN ('PON_BID_HEADERS',
4295: 'PON_BID_ITEM_PRICES')
4296: and ad.pk1_value = to_char(p_auction_header_id)
4297: and ad.pk2_value = to_char(pbhs.bid_number)
4298: --and categories.name=pon_auction_pkg.g_supplier_attachment
4299: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)