[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
1701: ,pa_tasks task
1702: ,gms_awards_all awrd
1703: ,hr_all_organization_units hrorg
1704: ,fnd_user fuser
1705: ,pon_bid_item_prices pbip
1706: where
1707: paip.auction_header_id = pah.auction_header_id
1708: and pbip.auction_header_id(+) = paip.auction_header_id
1709: and pbip.bid_number(+) = p_bid_number
2252: AND paip.line_number = pbsm.line_number
2253: AND pbsm.shipment_type = 'PRICE BREAK'
2254: AND mp.organization_id(+) = pbsm.ship_to_organization_id
2255: AND loc.location_id(+) = pbsm.ship_to_location_id
2256: and exists (select 1 from pon_bid_item_prices where bid_number=pbsm.bid_number and line_number=pbsm.line_number)
2257:
2258: UNION ALL
2259:
2260: SELECT pas.auction_header_id,
2289: AND paip.line_number = pas.line_number
2290: AND pas.shipment_type = 'PRICE BREAK'
2291: AND mp.organization_id(+) = pas.ship_to_organization_id
2292: AND loc.location_id(+) = pas.ship_to_location_id
2293: and not exists (select 1 from pon_bid_item_prices where bid_number=p_bid_number and line_number=paip.line_number)
2294: ) ORDER BY line_number,bid_shipment_number asc
2295: ) as ITEM_PRICE_BREAKS,
2296: CURSOR (
2297: (
2318: and pbsm.auction_shipment_number = pas.shipment_number(+)
2319: AND paip.auction_header_id = pbsm.auction_header_id
2320: AND paip.line_number = pbsm.line_number
2321: AND pbsm.shipment_type = 'QUANTITY BASED'
2322: and exists (select 1 from pon_bid_item_prices where bid_number=pbsm.bid_number and line_number=pbsm.line_number)
2323:
2324: UNION ALL
2325:
2326: SELECT pas.auction_header_id,
2340: WHERE pas.auction_header_id = pah.auction_header_id
2341: AND paip.auction_header_id = pas.auction_header_id
2342: AND paip.line_number = pas.line_number
2343: AND pas.shipment_type = 'QUANTITY BASED'
2344: and not exists (select 1 from pon_bid_item_prices where bid_number=p_bid_number and line_number=paip.line_number)
2345: ) ORDER BY line_number,bid_shipment_number asc
2346: ) as ITEM_QUANTITY_TIERS,
2347: CURSOR (
2348: (SELECT
2419: AND lkp1.lookup_type(+) = 'PAYMENT TYPE'
2420: AND pay.uom_code = uom_tl.uom_code(+)
2421: AND uom_tl.language(+) = l_printing_language
2422: AND fuser.user_id(+) = pay.work_approver_user_id
2423: AND not exists (select 1 from pon_bid_item_prices where bid_number = p_bid_number and line_number=pay.line_number)
2424: UNION ALL
2425: SELECT
2426: pbp.auction_header_id
2427: ,pbp.BID_PAYMENT_ID payment_id
2483: po_lookup_codes lkp1,
2484: fnd_territories_tl terr,
2485: mtl_units_of_measure_tl uom_tl,
2486: pon_bid_payments_shipments pbp,
2487: pon_bid_item_prices pbip
2488: WHERE
2489: pbp.bid_number = pbhs.bid_number
2490: AND pbp.auction_header_id = pay.auction_header_id(+)
2491: AND pbip.bid_number = pbp.bid_number
2703: fnd_document_categories_tl categories_tl
2704: where d.document_id = ad.document_id
2705: and
2706: ad.entity_name IN ('PON_BID_HEADERS',
2707: 'PON_BID_ITEM_PRICES')
2708: and ad.pk1_value = to_char(p_auction_header_id)
2709: and ad.pk2_value = to_char(pbhs.bid_number)
2710: --and categories.name=pon_auction_pkg.g_supplier_attachment
2711: and ((l_attach_categ_option = 1 AND categories.name = pon_auction_pkg.g_supplier_attachment)