PON_AUCTION_HEADERS_ALL_V

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name

AUCTION_HEADER_ID AUCTION_TITLE AUCTION_STATUS AWARD_STATUS CONTRACT_TYPE PERSON_ID OPEN_BIDDING_DATE CLOSE_BIDDING_DATE ORIGINAL_CLOSE_BIDDING_DATE VIEW_BY_DATE AWARD_BY_DATE PUBLISH_DATE CANCEL_DATE BID_VISIBILITY_CODE BID_LIST_TYPE BID_FREQUENCY_CODE BID_SCOPE_CODE AUTO_EXTEND_FLAG AUTO_EXTEND_NUMBER NUMBER_OF_EXTENSIONS NUMBER_OF_BIDS MIN_BID_DECREMENT PRICE_DRIVEN_AUCTION_FLAG PAYMENT_TERMS_ID FREIGHT_TERMS_CODE FOB_CODE CARRIER_ID CURRENCY_CODE RATE_TYPE RATE_DATE LANGUAGE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN AUTO_EXTEND_ALL_LINES_FLAG ALLOW_OTHER_BID_CURRENCY_FLAG AUTO_EXTEND_DURATION PUBLISH_RATES_TO_BIDDERS_FLAG ATTRIBUTES_EXIST EVENT_ID EVENT_TITLE SEALED_AUCTION_STATUS SEALED_ACTUAL_UNLOCK_DATE SEALED_ACTUAL_UNSEAL_DATE SEALED_UNLOCK_PERSON_ID SEALED_UNSEAL_PERSON_ID PO_START_DATE PO_END_DATE PO_AGREED_AMOUNT MIN_BID_CHANGE_TYPE FULL_QUANTITY_BID_CODE NUMBER_PRICE_DECIMALS AUTO_EXTEND_TYPE_FLAG AUCTION_ORIGINATION_CODE AUCTION_HEADER_ID_ORIG_ROUND AUCTION_HEADER_ID_PREV_ROUND AUCTION_ROUND_NUMBER AUTOEXTEND_CHANGED_FLAG DOCTYPE_ID VERSION_NUM SHOW_BIDDER_NOTES DRAFT_LOCKED DRAFT_LOCKED_BY_PERSON_ID DRAFT_LOCKED_DATE DRAFT_UNLOCKED_BY_PERSON_ID DRAFT_UNLOCKED_DATE BID_RANKING RANK_INDICATOR SHOW_BIDDER_SCORES OPEN_AUCTION_NOW_FLAG PUBLISH_AUCTION_NOW_FLAG TEMPLATE_ID REMINDER_DATE PRC_BU_ID HAS_PE_FOR_ALL_ITEMS HAS_PRICE_ELEMENTS PO_MIN_REL_AMOUNT OUTCOME_STATUS SOURCE_REQS_FLAG AWARD_COMPLETE_DATE NEG_APPROVAL_STATUS SOURCE_DOC_ID SOURCE_DOC_NUMBER SOURCE_DOC_MSG SOURCE_DOC_LINE_MSG SOURCE_DOC_MSG_APP AUCTION_SORTCOL NAME DOCUMENT_NUMBER NEGOTIATION_STATUS SHARE_AWARD_DECISION DESCRIPTION TEMPLATE_SCOPE TEMPLATE_STATUS IS_TEMPLATE_FLAG AMENDMENT_NUMBER AMENDMENT_DESCRIPTION AUCTION_HEADER_ID_ORIG_AMEND AUCTION_HEADER_ID_PREV_AMEND AWARD_APPROVAL_FLAG AWARD_APPROVAL_STATUS HDR_ATTR_ENABLE_WEIGHTS HDR_ATTR_DISPLAY_SCORE HDR_ATTR_MAXIMUM_SCORE CONTERMS_EXIST_FLAG CONTERMS_ARTICLES_UPD_DATE CONTERMS_DELIV_UPD_DATE AWARD_MODE HAS_HDR_ATTR_FLAG AWARD_DATE SUPPL_NEGOTIATION_STATUS MAX_BID_COLOR_SEQUENCE_ID HAS_ITEMS_FLAG PF_TYPE_ALLOWED SUPPLIER_VIEW_TYPE IS_PAUSED PAUSE_REMARKS LAST_PAUSE_DATE ACTUAL_CLOSE_BIDDING_DATE MAX_DOCUMENT_LINE_NUM TEAM_SCORING_ENABLED_FLAG HAS_SCORING_TEAMS_FLAG SCORING_LOCK_DATE SCORING_LOCK_PERSON_ID STYLE_ID LINE_ATTRIBUTE_ENABLED_FLAG LINE_MAS_ENABLED_FLAG PRICE_ELEMENT_ENABLED_FLAG RFI_LINE_ENABLED_FLAG LOT_ENABLED_FLAG GROUP_ENABLED_FLAG LARGE_NEG_ENABLED_FLAG HDR_ATTRIBUTE_ENABLED_FLAG NEG_TEAM_ENABLED_FLAG PROXY_BIDDING_ENABLED_FLAG POWER_BIDDING_ENABLED_FLAG AUTO_EXTEND_ENABLED_FLAG PO_STYLE_ID PROJECT_ID REQUEST_ID REQUEST_DATE REQUESTED_BY IMPORT_FILE_NAME NUMBER_OF_LINES LAST_LINE_NUMBER GLOBAL_TEMPLATE_FLAG CONTRACT_TEMPLATE_ID BID_DECREMENT_METHOD DISPLAY_BEST_PRICE_BLIND_FLAG STAGGERED_CLOSING_INTERVAL FIRST_LINE_CLOSE_DATE ENFORCE_PREVRND_BID_PRICE_FLAG AUTO_EXTEND_MIN_TRIGGER_RANK PRICE_TIERS_INDICATOR QTY_PRICE_TIERS_ENABLED_FLAG TWO_PART_FLAG TECHNICAL_LOCK_STATUS TECHNICAL_EVALUATION_STATUS TECHNICAL_ACTUAL_UNLOCK_DATE TECHNICAL_ACTUAL_UNSEAL_DATE TECHNICAL_UNLOCK_PERSON_ID TECHNICAL_UNSEAL_PERSON_ID ALTERNATE_LINES_ENABLED_FLAG ALLOW_ALTERNATE_LINES BID_REVISION_TYPE BID_REVISION_TYPE_DSP_FLAG LINE_DEFAULTS_ENABLED_FLAG LINE_DEFAULTS_EXIST_FLAG RESP_SPSHET_ENABLED_FLAG RESP_XML_SPSHET_ENABLED_FLAG RESP_LINES_SPSHET_ENABLED_FLAG RESP_REQT_SPSHET_ENABLED_FLAG IS_CREATED_FROM_REST ALLOW_CONTRACT_CRT_FLAG CONTRACT_ID INTERNAL_CF_ENABLED_FLAG OVERALL_RESP_RANK_ENABLED_FLAG DISPLAY_TRANS_AMOUNT_SUPP_FLAG DISPLAY_BID_RANK_TO_SUPP_FLAG CONTRACT_ERROR_MSG INTERNAL_CF_LINES_ENABLED_FLAG DISPLAY_TRANS_RANK_SUPP_FLAG RETAINAGE_ENABLED_FLAG COVER_TEXT_GEN_AI_ENABLED_FLAG

Query

SQL_Statement

SELECT AH.AUCTION_HEADER_ID, AH.AUCTION_TITLE, AH.AUCTION_STATUS, AH.AWARD_STATUS, AH.CONTRACT_TYPE, AH.PERSON_ID, AH.OPEN_BIDDING_DATE, decode ( NVL( AH.IS_PAUSED, 'N'), 'Y', ( sysdate + ( ah.close_bidding_date - ah.last_pause_date ) ) , ah.close_bidding_date )CLOSE_BIDDING_DATE, AH.ORIGINAL_CLOSE_BIDDING_DATE, AH.VIEW_BY_DATE, AH.AWARD_BY_DATE, AH.PUBLISH_DATE, AH.CANCEL_DATE, AH.BID_VISIBILITY_CODE, AH.BID_LIST_TYPE, AH.BID_FREQUENCY_CODE, AH.BID_SCOPE_CODE, AH.AUTO_EXTEND_FLAG, AH.AUTO_EXTEND_NUMBER, AH.NUMBER_OF_EXTENSIONS, AH.NUMBER_OF_BIDS, AH.MIN_BID_DECREMENT, AH.PRICE_DRIVEN_AUCTION_FLAG, AH.PAYMENT_TERMS_ID, AH.FREIGHT_TERMS_CODE, AH.FOB_CODE, AH.CARRIER_ID, AH.CURRENCY_CODE, AH.RATE_TYPE, AH.RATE_DATE, AH.LANGUAGE_CODE, AH.CREATION_DATE, AH.CREATED_BY, AH.LAST_UPDATE_DATE, AH.LAST_UPDATED_BY, AH.LAST_UPDATE_LOGIN, AH.AUTO_EXTEND_ALL_LINES_FLAG, AH.ALLOW_OTHER_BID_CURRENCY_FLAG, AH.AUTO_EXTEND_DURATION, AH.PUBLISH_RATES_TO_BIDDERS_FLAG, AH.ATTRIBUTES_EXIST, AH.EVENT_ID, AH.EVENT_TITLE, AH.SEALED_AUCTION_STATUS, AH.SEALED_ACTUAL_UNLOCK_DATE, AH.SEALED_ACTUAL_UNSEAL_DATE, AH.SEALED_UNLOCK_PERSON_ID, AH.SEALED_UNSEAL_PERSON_ID, AH.PO_START_DATE, AH.PO_END_DATE, AH.PO_AGREED_AMOUNT, AH.MIN_BID_CHANGE_TYPE, AH.FULL_QUANTITY_BID_CODE, AH.NUMBER_PRICE_DECIMALS, AH.AUTO_EXTEND_TYPE_FLAG, AH.AUCTION_ORIGINATION_CODE, AH.AUCTION_HEADER_ID_ORIG_ROUND, AH.AUCTION_HEADER_ID_PREV_ROUND, AH.AUCTION_ROUND_NUMBER, AH.AUTOEXTEND_CHANGED_FLAG, AH.DOCTYPE_ID, AH.VERSION_NUM, AH.SHOW_BIDDER_NOTES, AH.DRAFT_LOCKED, AH.DRAFT_LOCKED_BY_PERSON_ID, AH.DRAFT_LOCKED_DATE, AH.DRAFT_UNLOCKED_BY_PERSON_ID, AH.DRAFT_UNLOCKED_DATE, AH.BID_RANKING, AH.RANK_INDICATOR, AH.SHOW_BIDDER_SCORES, AH.OPEN_AUCTION_NOW_FLAG, AH.PUBLISH_AUCTION_NOW_FLAG, AH.TEMPLATE_ID, AH.REMINDER_DATE, AH.PRC_BU_ID, AH.HAS_PE_FOR_ALL_ITEMS, AH.HAS_PRICE_ELEMENTS, AH.PO_MIN_REL_AMOUNT, AH.OUTCOME_STATUS, AH.SOURCE_REQS_FLAG, AH.AWARD_COMPLETE_DATE, AH.NEG_APPROVAL_STATUS, AH.SOURCE_DOC_ID, AH.SOURCE_DOC_NUMBER, AH.SOURCE_DOC_MSG , AH.SOURCE_DOC_LINE_MSG, AH.SOURCE_DOC_MSG_APP, (AH.AUCTION_HEADER_ID_ORIG_ROUND *100000000) + NVL(AH.AUCTION_ROUND_NUMBER, 0)*10000+NVL(AH.AMENDMENT_NUMBER, 0) AUCTION_SORTCOL, HAOU.NAME, aH.DOCUMENT_NUMBER, decode(auction_status, 'CANCELLED', 'CANCELLED', 'AMENDED', 'AMENDED', 'DRAFT', 'DRAFT', decode( NVL( ah.is_paused, 'N'), 'Y', 'PAUSED', decode(sign(nvl(view_by_date, open_bidding_date) - sysdate), 1, 'SUBMITTED', decode(sign(open_bidding_date - sysdate), 1, 'PREVIEW', decode(sign(close_bidding_date - sysdate), 1, 'ACTIVE', decode(auction_status, 'ACTIVE', decode(award_status, 'NO', decode(award_approval_status, 'APPROVED', 'AWARD_APPROVED', 'REJECTED', 'AWARD_REJECTED', 'INPROCESS', 'AWARD_APPROVAL_INPROCESS', 'CLOSED') , 'PARTIAL', decode(award_approval_status, 'APPROVED', 'AWARD_APPROVED', 'REJECTED', 'AWARD_REJECTED', 'INPROCESS', 'AWARD_APPROVAL_INPROCESS', 'AWARD_IN_PROG'), 'AWARDED', decode(award_approval_status, 'APPROVED', 'AWARD_APPROVED', 'REJECTED', 'AWARD_REJECTED', 'INPROCESS', 'AWARD_APPROVAL_INPROCESS', 'AWARD_IN_PROG')), 'AUCTION_CLOSED', decode(award_status, 'NO', 'ROUND_COMPLETED', 'QUALIFIED', 'RFI_COMPLETED', decode(outcome_status, 'NOT_ALLOCATED', 'AWARD_COMPLETED', 'PARTIALLY_ALLOCATED', 'ALLOCATION_IN_PROG', 'ALLOCATED', 'ALLOCATION_IN_PROG', 'ALLOCATION_NOT_REQUIRED', 'AWARD_COMPLETED', outcome_status)))))))) NEGOTIATION_STATUS, AH.SHARE_AWARD_DECISION, AH.DESCRIPTION, AH.TEMPLATE_SCOPE, AH.TEMPLATE_STATUS, AH.IS_TEMPLATE_FLAG, AH.Amendment_number, AH.Amendment_description, AH.auction_header_id_orig_amend, AH.auction_header_id_prev_amend, aH.award_approval_flag, aH.award_approval_status, AH.HDR_ATTR_ENABLE_WEIGHTS, AH.HDR_ATTR_DISPLAY_SCORE, AH.HDR_ATTR_MAXIMUM_SCORE, AH.CONTERMS_EXIST_FLAG, AH.CONTERMS_ARTICLES_UPD_DATE, AH.CONTERMS_DELIV_UPD_DATE, AH.AWARD_MODE, AH.HAS_HDR_ATTR_FLAG, AH.AWARD_DATE, decode(auction_status, 'CANCELLED', 'CANCELLED', 'AMENDED', 'AMENDED', 'DRAFT', 'DRAFT', decode(NVL(ah.is_paused, 'N'), 'Y', 'PAUSED', decode(sign(nvl(view_by_date, open_bidding_date) - sysdate), 1, 'SUBMITTED', decode(sign(open_bidding_date-sysdate), 1, 'PREVIEW', decode(sign(close_bidding_date - sysdate), 1, 'ACTIVE', 'CLOSED'))))) SUPPL_NEGOTIATION_STATUS, AH.max_bid_color_sequence_id, AH.has_items_flag, AH.pf_type_allowed, AH.supplier_view_type, AH.IS_PAUSED, AH.PAUSE_REMARKS, AH.LAST_PAUSE_DATE, AH.CLOSE_BIDDING_DATE ACTUAL_CLOSE_BIDDING_DATE, AH.MAX_DOCUMENT_LINE_NUM, AH.TEAM_SCORING_ENABLED_FLAG, AH.HAS_SCORING_TEAMS_FLAG, AH.SCORING_LOCK_DATE, AH.SCORING_LOCK_PERSON_ID, AH.STYLE_ID, AH.LINE_ATTRIBUTE_ENABLED_FLAG, AH.LINE_MAS_ENABLED_FLAG, AH.PRICE_ELEMENT_ENABLED_FLAG, AH.RFI_LINE_ENABLED_FLAG, AH.LOT_ENABLED_FLAG, AH.GROUP_ENABLED_FLAG, AH.LARGE_NEG_ENABLED_FLAG, AH.HDR_ATTRIBUTE_ENABLED_FLAG, AH.NEG_TEAM_ENABLED_FLAG, AH.PROXY_BIDDING_ENABLED_FLAG, AH.POWER_BIDDING_ENABLED_FLAG, AH.AUTO_EXTEND_ENABLED_FLAG, AH.PO_STYLE_ID, AH.PROJECT_ID, AH.REQUEST_ID, AH.REQUEST_DATE, AH.REQUESTED_BY, AH.IMPORT_FILE_NAME, AH.NUMBER_OF_LINES, AH.LAST_LINE_NUMBER, AH.GLOBAL_TEMPLATE_FLAG, AH.CONTRACT_TEMPLATE_ID, AH.BID_DECREMENT_METHOD, AH.DISPLAY_BEST_PRICE_BLIND_FLAG, AH.STAGGERED_CLOSING_INTERVAL, AH.FIRST_LINE_CLOSE_DATE, AH.ENFORCE_PREVRND_BID_PRICE_FLAG, AH.AUTO_EXTEND_MIN_TRIGGER_RANK, AH.PRICE_TIERS_INDICATOR, AH.QTY_PRICE_TIERS_ENABLED_FLAG, AH.TWO_PART_FLAG, AH.TECHNICAL_LOCK_STATUS, AH.TECHNICAL_EVALUATION_STATUS, AH.TECHNICAL_ACTUAL_UNLOCK_DATE, AH.TECHNICAL_ACTUAL_UNSEAL_DATE, AH.TECHNICAL_UNLOCK_PERSON_ID, AH.TECHNICAL_UNSEAL_PERSON_ID, AH.ALTERNATE_LINES_ENABLED_FLAG, AH.ALLOW_ALTERNATE_LINES, AH.BID_REVISION_TYPE, AH.BID_REVISION_TYPE_DSP_FLAG, AH.LINE_DEFAULTS_ENABLED_FLAG,AH.LINE_DEFAULTS_EXIST_FLAG,AH.RESP_SPSHET_ENABLED_FLAG,AH.RESP_XML_SPSHET_ENABLED_FLAG,AH.RESP_LINES_SPSHET_ENABLED_FLAG,AH.RESP_REQT_SPSHET_ENABLED_FLAG,AH.IS_CREATED_FROM_REST,AH.ALLOW_CONTRACT_CRT_FLAG,AH.CONTRACT_ID,AH.INTERNAL_CF_ENABLED_FLAG,AH.OVERALL_RESP_RANK_ENABLED_FLAG,AH.DISPLAY_TRANS_AMOUNT_SUPP_FLAG,AH.DISPLAY_BID_RANK_TO_SUPP_FLAG,AH.CONTRACT_ERROR_MSG,AH.INTERNAL_CF_LINES_ENABLED_FLAG,AH.DISPLAY_TRANS_RANK_SUPP_FLAG,AH.RETAINAGE_ENABLED_FLAG,AH.COVER_TEXT_GEN_AI_ENABLED_FLAG FROM HR_ALL_ORGANIZATION_UNITS_TL HAOU,PON_AUCTION_HEADERS_ALL AH WHERE HAOU.organization_id(+) = AH.PRC_BU_ID AND HAOU.language(+) =userenv('LANG')