PON_AUCTION_HEADERS

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 NUMBER_OF_LINES STAGGERED_CLOSING_INTERVAL FIRST_LINE_CLOSE_DATE PRICE_TIERS_INDICATOR ENFORCE_PREVRND_BID_PRICE_FLAG ALTERNATE_LINES_ENABLED_FLAG ALLOW_ALTERNATE_LINES BID_REVISION_TYPE BID_REVISION_TYPE_DSP_FLAG

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

NUMBER_OF_LINES

STAGGERED_CLOSING_INTERVAL

FIRST_LINE_CLOSE_DATE

PRICE_TIERS_INDICATOR

ENFORCE_PREVRND_BID_PRICE_FLAG

ALTERNATE_LINES_ENABLED_FLAG

ALLOW_ALTERNATE_LINES

BID_REVISION_TYPE

BID_REVISION_TYPE_DSP_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.NUMBER_OF_LINES, AH.STAGGERED_CLOSING_INTERVAL, AH.FIRST_LINE_CLOSE_DATE, AH.PRICE_TIERS_INDICATOR, AH.ENFORCE_PREVRND_BID_PRICE_FLAG, AH.ALTERNATE_LINES_ENABLED_FLAG, AH.ALLOW_ALTERNATE_LINES, AH.BID_REVISION_TYPE, AH.BID_REVISION_TYPE_DSP_FLAG FROM HR_ALL_ORGANIZATION_UNITS_TL HAOU, PON_AUCTION_HEADERS AH WHERE HAOU.organization_id(+) = AH.PRC_BU_ID AND HAOU.language(+) =userenv('LANG')

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.NUMBER_OF_LINES, AH.STAGGERED_CLOSING_INTERVAL, AH.FIRST_LINE_CLOSE_DATE, AH.PRICE_TIERS_INDICATOR, AH.ENFORCE_PREVRND_BID_PRICE_FLAG, AH.ALTERNATE_LINES_ENABLED_FLAG, AH.ALLOW_ALTERNATE_LINES, AH.BID_REVISION_TYPE, AH.BID_REVISION_TYPE_DSP_FLAG FROM HR_ALL_ORGANIZATION_UNITS_TL HAOU, PON_AUCTION_HEADERS AH WHERE HAOU.organization_id(+) = AH.PRC_BU_ID AND HAOU.language(+) =userenv('LANG')