[Home] [Help]
1321: entity_loc.country entity_country_code,
1322: entity_loc.region_1 entity_region_1,
1323: entity_loc.region_2 entity_region_2,
1324: entity_loc.region_3 entity_region_3,
1325: 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,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1322: entity_loc.region_1 entity_region_1,
1323: entity_loc.region_2 entity_region_2,
1324: entity_loc.region_3 entity_region_3,
1325: 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,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1323: entity_loc.region_2 entity_region_2,
1324: entity_loc.region_3 entity_region_3,
1325: 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,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1324: entity_loc.region_3 entity_region_3,
1325: 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,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1325: 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,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1333: pah.time_zone,
1326: 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,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1333: pah.time_zone,
1334: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
1327: 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,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1333: pah.time_zone,
1334: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
1335: pah.open_auction_now_flag,
1328: 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,
1329: 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,
1330: pon_oa_util_pkg.display_date_time(pah.publish_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') publish_date,
1331: pon_oa_util_pkg.display_date_time(pah.close_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') close_date,
1332: pon_oa_util_pkg.display_date_time(pah.cancel_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') cancel_date,
1333: pah.time_zone,
1334: pon_auction_pkg.get_timezone_description(p_client_time_zone,l_printing_language) display_time_zone,
1335: pah.open_auction_now_flag,
1336: pah.publish_auction_now_flag,
1382: pah.sealed_actual_unlock_date,
1383: pah.sealed_actual_unseal_date,
1384: pah.mode_of_transport,
1385: pah.mode_of_transport_code,
1386: 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,
1387: 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,
1388: to_char(pah.po_agreed_amount*l_rate, l_amount_mask) po_agreed_amount,
1389: pah.min_bid_change_type,
1390: pah.full_quantity_bid_code,
1383: pah.sealed_actual_unseal_date,
1384: pah.mode_of_transport,
1385: pah.mode_of_transport_code,
1386: 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,
1387: 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,
1388: to_char(pah.po_agreed_amount*l_rate, l_amount_mask) po_agreed_amount,
1389: pah.min_bid_change_type,
1390: pah.full_quantity_bid_code,
1391: pah.number_price_decimals,
1432: pah.has_hdr_attr_flag ,
1433: nvl(pah.has_items_flag,'Y') has_items_flag,
1434: decode(pah.staggered_closing_interval, null, 'N', 'Y') staggered_closing_enabled,
1435: pah.staggered_closing_interval,
1436: 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,
1437: doctypes.internal_name,
1438: l_prev_rnd_doctype prev_rnd_internal_name,
1439: po_setup_s1.get_services_enabled_flag() is_services_enabled,
1440: l_contracts_installed as is_contracts_installed,
1466: doctypes.doctype_group_name,
1467: -- bidpdf: response status
1468: fl_bid.meaning response_status,
1469: -- bidpdf: Response Valid Until
1470: 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,
1471: -- bidpdf: supplier address
1472: l_supplier_address_line1 supplier_address_line1,
1473: l_supplier_address_line2 supplier_address_line2,
1474: l_supplier_address_line3 supplier_address_line3,
1484: pbhs.bid_currency_code bid_currency_selected, --Response Currency
1485: pbhs.bidders_bid_number reference_number, --Reference Number
1486: pbhs.note_to_auction_owner note_to_buyer, --Note to Buyer
1487: --bidpdf: Response Received Time value
1488: 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,
1489: pbhs.surrog_bid_flag surrog_bid_flag, --Surrogate Bid Flag
1490: pon_printing_pkg.get_user_email(hp1.party_id) email,
1491: pah.abstract_details,
1492: fl_security.meaning security_level,
1492: fl_security.meaning security_level,
1493: pah.approval_status,
1494: ps.display_name outcome,
1495: nvl(gdct.description, gdct.user_conversion_type) rate_type_display,
1496: pon_oa_util_pkg.display_date(pah.rate_date,
1497: p_client_time_zone,
1498: p_server_time_zone,
1499: p_date_format, 'N') rate_date_display,
1500: pah.award_approval_flag,
1551: Select
1552: paip.item_number|| nvl2(paip.item_revision, ', ', '') || paip.item_revision || jobs.name item,
1553: paip.line_number,
1554: paip.item_description,
1555: 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,
1556: paip.category_id,
1557: paip.category_name,
1558: paip.ip_category_id,
1559: icx.category_name ip_category_name,
1564: pbip.note_to_auction_owner,
1565: -- bidpdf: add bid price info
1566: 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,
1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
1568: 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,
1569: --in MAS case, pbip.quantity is null, use paip.quantity instead
1570: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(pah.contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
1571: --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,
1572: --bidpdf: Bid Minimum Release Amount
1676: ,awrd.award_number project_award_number
1677: ,paip.project_expenditure_type project_expenditure_type
1678: ,paip.project_exp_organization_id project_exp_organization_id
1679: ,hrorg.name project_exp_organization_name
1680: ,pon_oa_util_pkg.display_date(paip.project_expenditure_item_date, p_client_time_zone,
1681: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
1682: ,NVL2(paip.work_approver_user_id, (SELECT per.full_name
1683: FROM per_all_people_f per
1684: WHERE per.person_id = fuser.employee_id
1753: tm.approver_flag,
1754: tm.menu_name,
1755: flkp.meaning member_access_type,
1756: tm.task_name,
1757: pon_oa_util_pkg.display_date(tm.target_date,
1758: p_client_time_zone,
1759: p_server_time_zone,
1760: p_date_format, 'N') target_date
1761: FROM
2228: pon_transform_bidding_pkg.calculate_price(pah.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),
2229: l_price_mask, l_price_precision)
2230: ) price,
2231:
2232: 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,
2233: 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,
2234: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
2235: pbsm.has_price_differentials_flag,
2236: pas.differential_response_type,
2229: l_price_mask, l_price_precision)
2230: ) price,
2231:
2232: 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,
2233: 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,
2234: nvl2(pbsm.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
2235: pbsm.has_price_differentials_flag,
2236: pas.differential_response_type,
2237: 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,
2270: pon_transform_bidding_pkg.calculate_price(pah.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),
2271: l_price_mask,
2272: l_price_precision
2273: ) price,
2274: 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,
2275: 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,
2276: nvl2(pas.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
2277: pas.has_price_differentials_flag,
2278: pas.differential_response_type,
2271: l_price_mask,
2272: l_price_precision
2273: ) price,
2274: 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,
2275: 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,
2276: nvl2(pas.ship_to_location_id, loc.location_code, mp.organization_code) ship_to,
2277: pas.has_price_differentials_flag,
2278: pas.differential_response_type,
2279: null bid_currency_price,
2369: ,pay.quantity
2370: ,pay.uom_code
2371: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2372: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2373: ,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
2374: ,pay.work_approver_user_id
2375: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2376: FROM per_all_people_f per
2377: WHERE per.person_id = fuser.employee_id
2389: ,awrd.award_number project_award_number
2390: ,pay.project_expenditure_type project_expenditure_type
2391: ,pay.project_exp_organization_id project_exp_organization_id
2392: ,hrorg.name project_exp_organization_name
2393: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
2394: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2395: ,null pay_item_price
2396: ,null amount_display
2397: ,null bid_promised_date
2446: ,pay.quantity
2447: ,pay.uom_code
2448: ,uom_tl.unit_of_measure_tl unit_of_measure_tl
2449: ,pon_printing_pkg.format_price(pay.target_price*l_rate, l_price_mask, l_price_precision) target_price
2450: ,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
2451: ,pay.work_approver_user_id
2452: ,NVL2(pay.work_approver_user_id, (SELECT per.full_name
2453: FROM per_all_people_f per
2454: WHERE per.person_id = fuser.employee_id
2466: ,awrd.award_number project_award_number
2467: ,pay.project_expenditure_type project_expenditure_type
2468: ,pay.project_exp_organization_id project_exp_organization_id
2469: ,hrorg.name project_exp_organization_name
2470: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
2471: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2472: ,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
2473: ,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
2474: ,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
2470: ,pon_oa_util_pkg.display_date(pay.project_expenditure_item_date, p_client_time_zone,
2471: p_server_time_zone, p_date_format, 'N') project_expenditure_item_date
2472: ,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
2473: ,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
2474: ,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
2475: FROM
2476: pon_auc_payments_shipments pay,
2477: pa_projects_all proj,
2478: pa_tasks task,