[Home] [Help]
2270: entity_loc.country entity_country_code,
2271: entity_loc.region_1 entity_region_1,
2272: entity_loc.region_2 entity_region_2,
2273: entity_loc.region_3 entity_region_3,
2274: pon_oa_util_pkg.display_date_time(pah.open_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') open_bidding_date,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2271: entity_loc.region_1 entity_region_1,
2272: entity_loc.region_2 entity_region_2,
2273: entity_loc.region_3 entity_region_3,
2274: pon_oa_util_pkg.display_date_time(pah.open_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') open_bidding_date,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2272: entity_loc.region_2 entity_region_2,
2273: entity_loc.region_3 entity_region_3,
2274: pon_oa_util_pkg.display_date_time(pah.open_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') open_bidding_date,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2273: entity_loc.region_3 entity_region_3,
2274: pon_oa_util_pkg.display_date_time(pah.open_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') open_bidding_date,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2274: pon_oa_util_pkg.display_date_time(pah.open_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') open_bidding_date,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2282: pah.time_zone,
2275: pon_oa_util_pkg.display_date_time(pah.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_bidding_date,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2282: pah.time_zone,
2283: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
2276: pon_oa_util_pkg.display_date_time(pah.original_close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') original_close_bidding_date,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2282: pah.time_zone,
2283: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
2284: pah.open_auction_now_flag,
2277: pon_oa_util_pkg.display_date_time(pah.view_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') view_by_date,
2278: pon_oa_util_pkg.display_date_time(pah.award_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') award_by_date,
2279: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
2280: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
2281: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
2282: pah.time_zone,
2283: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
2284: pah.open_auction_now_flag,
2285: pah.publish_auction_now_flag,
2331: pah.sealed_actual_unlock_date,
2332: pah.sealed_actual_unseal_date,
2333: pah.mode_of_transport,
2334: pah.mode_of_transport_code,
2335: pon_oa_util_pkg.display_date(pah.po_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') po_start_date,
2336: pon_oa_util_pkg.display_date(pah.po_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') po_end_date,
2337: to_char(pah.po_agreed_amount*l_rate, l_amount_mask) po_agreed_amount,
2338: pah.min_bid_change_type,
2339: pah.full_quantity_bid_code,
2332: pah.sealed_actual_unseal_date,
2333: pah.mode_of_transport,
2334: pah.mode_of_transport_code,
2335: pon_oa_util_pkg.display_date(pah.po_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') po_start_date,
2336: pon_oa_util_pkg.display_date(pah.po_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') po_end_date,
2337: to_char(pah.po_agreed_amount*l_rate, l_amount_mask) po_agreed_amount,
2338: pah.min_bid_change_type,
2339: pah.full_quantity_bid_code,
2340: pah.number_price_decimals,
2383: pah.has_hdr_attr_flag ,
2384: nvl(pah.has_items_flag,'Y') has_items_flag,
2385: decode(pah.staggered_closing_interval, null, 'N', 'Y') staggered_closing_enabled,
2386: pah.staggered_closing_interval,
2387: pon_oa_util_pkg.display_date_time(pah.first_line_close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') first_line_close_date,
2388: doctypes.internal_name,
2389: l_prev_rnd_doctype prev_rnd_internal_name,
2390: po_setup_s1.get_services_enabled_flag() is_services_enabled,
2391: l_contracts_installed as is_contracts_installed,
2418: doctypes.doctype_group_name,
2419: -- bidpdf: response status
2420: fl_bid.meaning response_status,
2421: -- bidpdf: Response Valid Until
2422: decode(pbhs.bid_expiration_date, null, '', pon_oa_util_pkg.display_date(pbhs.bid_expiration_date, p_client_time_zone, p_server_time_zone, p_date_format,'N')) response_valid_until,
2423: -- bidpdf: supplier address
2424: l_supplier_address_line1 supplier_address_line1,
2425: l_supplier_address_line2 supplier_address_line2,
2426: l_supplier_address_line3 supplier_address_line3,
2436: pbhs.bid_currency_code bid_currency_selected, --Response Currency
2437: pbhs.bidders_bid_number reference_number, --Reference Number
2438: pbhs.note_to_auction_owner note_to_buyer, --Note to Buyer
2439: --bidpdf: Response Received Time value
2440: pon_oa_util_pkg.display_date_time(pbhs.surrog_bid_receipt_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_received_time,
2441: pbhs.surrog_bid_flag surrog_bid_flag, --Surrogate Bid Flag
2442: pon_printing_pkg.get_user_email(hp1.party_id) email,
2443: pah.abstract_details,
2444: fl_security.meaning security_level,
2444: fl_security.meaning security_level,
2445: pah.approval_status,
2446: ps.display_name outcome,
2447: nvl(gdct.description, gdct.user_conversion_type) rate_type_display,
2448: pon_oa_util_pkg.display_date(pah.rate_date,
2449: p_client_time_zone,
2450: p_server_time_zone,
2451: p_date_format, 'N') rate_date_display,
2452: pah.award_approval_flag,
2696: nvl2(paip.item_revision, ', ', '') ||
2697: paip.item_revision || jobs.name item,
2698: paip.line_number,
2699: paip.item_description,
2700: pon_oa_util_pkg.display_date_time(paip.close_bidding_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') line_close_bidding_date,
2701: paip.category_id,
2702: paip.category_name,
2703: paip.ip_category_id,
2704: icx.category_name ip_category_name,
2709: pbip.note_to_auction_owner,
2710: -- bidpdf: add bid price info
2711: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_price, l_price_mask, l_price_precision)) bid_currency_price,
2712: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
2713: pon_oa_util_pkg.display_date_time(pbip.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date,
2714: --in MAS case, pbip.quantity is null, use paip.quantity instead
2715: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(l_contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
2716: --response/inquiry/server/ViewBidItemsVORowImpl.java:getBidTotalDisplay(): exchange_rate * PON_TRANSFORM_BIDDING_PKG.calculate_quote_amount (paip.auction_header_id, pbip.line_number, pbip.bid_number, 'TRANSFORMED', 12637, 12438, -1) bid_amount,
2717: --bidpdf: Bid Minimum Release Amount
2821: ,awrd.award_number project_award_number
2822: ,paip.project_expenditure_type project_expenditure_type
2823: ,paip.project_exp_organization_id project_exp_organization_id
2824: ,hrorg.name project_exp_organization_name
2825: ,pon_oa_util_pkg.display_date(paip.project_expenditure_item_date, p_client_time_zone,
2826: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2827: ,NVL2(paip.work_approver_user_id, (SELECT per.full_name
2828: FROM per_all_people_f per
2829: WHERE per.person_id = fuser.employee_id
2928: ,pay.quantity
2929: ,pay.uom_code
2930: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2931: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2932: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
2933: ,pay.work_approver_user_id
2934: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2935: FROM per_all_people_f per
2936: WHERE per.person_id = fuser.employee_id
2948: ,awrd.award_number project_award_number
2949: ,pay.project_expenditure_type project_expenditure_type
2950: ,pay.project_exp_organization_id project_exp_organization_id
2951: ,hrorg.name project_exp_organization_name
2952: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
2953: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2954: ,null pay_item_price
2955: ,null amount_display
2956: ,null bid_promised_date
3004: ,pay.quantity
3005: ,pay.uom_code
3006: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
3007: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
3008: ,pon_oa_util_pkg.display_date_time(pay.need_by_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') need_by_date
3009: ,pay.work_approver_user_id
3010: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
3011: FROM per_all_people_f per
3012: WHERE per.person_id = fuser.employee_id
3024: ,awrd.award_number project_award_number
3025: ,pay.project_expenditure_type project_expenditure_type
3026: ,pay.project_exp_organization_id project_exp_organization_id
3027: ,hrorg.name project_exp_organization_name
3028: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
3029: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
3030: ,decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbp.price, l_price_mask,l_price_precision), pon_printing_pkg.format_price(pbp.bid_currency_price,l_price_mask,l_price_precision)) pay_item_price
3031: ,to_char(decode(pbp.quantity,null,decode(pbip.quantity, null, 1,pbip.quantity),pbp.quantity)*decode(p_user_view_type, 'BUYER',pbp.price,pbp.bid_currency_price), l_amount_mask) amount_display
3032: ,pon_oa_util_pkg.display_date_time(pbp.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date
3028: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
3029: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
3030: ,decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbp.price, l_price_mask,l_price_precision), pon_printing_pkg.format_price(pbp.bid_currency_price,l_price_mask,l_price_precision)) pay_item_price
3031: ,to_char(decode(pbp.quantity,null,decode(pbip.quantity, null, 1,pbip.quantity),pbp.quantity)*decode(p_user_view_type, 'BUYER',pbp.price,pbp.bid_currency_price), l_amount_mask) amount_display
3032: ,pon_oa_util_pkg.display_date_time(pbp.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date
3033: FROM
3034: pon_auc_payments_shipments pay,
3035: pa_projects_all proj,
3036: pa_tasks_expend_v task,
3307: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
3308: l_price_mask, l_price_precision)
3309: ) price,
3310:
3311: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
3312: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_end_date,
3313: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
3314: pbsm.has_price_differentials_flag,
3315: pas.differential_response_type,
3308: l_price_mask, l_price_precision)
3309: ) price,
3310:
3311: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
3312: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_end_date,
3313: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
3314: pbsm.has_price_differentials_flag,
3315: pas.differential_response_type,
3316: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_price,l_price_mask, l_price_precision)) bid_currency_price,
3348: pon_transform_bidding_pkg.calculate_price(p_auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
3349: l_price_mask,
3350: l_price_precision
3351: ) price,
3352: PON_OA_UTIL_PKG.DISPLAY_DATE(pas.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
3353: PON_OA_UTIL_PKG.DISPLAY_DATE(pas.effective_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_end_date,
3354: nvl2(pas.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
3355: pas.has_price_differentials_flag,
3356: pas.differential_response_type,
3349: l_price_mask,
3350: l_price_precision
3351: ) price,
3352: PON_OA_UTIL_PKG.DISPLAY_DATE(pas.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
3353: PON_OA_UTIL_PKG.DISPLAY_DATE(pas.effective_end_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_end_date,
3354: nvl2(pas.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
3355: pas.has_price_differentials_flag,
3356: pas.differential_response_type,
3357: null bid_currency_price,
3512: tm.approver_flag,
3513: tm.menu_name,
3514: flkp.meaning member_access_type,
3515: tm.task_name,
3516: pon_oa_util_pkg.display_date(tm.target_date,
3517: p_client_time_zone,
3518: p_server_time_zone,
3519: p_date_format, 'N') target_date
3520: FROM