PON_BID_HEADERS

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
LAST_UPDATE_DATE NOTE_TO_AUCTION_OWNER RATE NOTE_TO_SUPPLIER DRAFT_LOCKED_DATE BIDDERS_BID_NUMBER CANCELLED_DATE PROXY_BID_FLAG DRAFT_LOCKED PUBLISH_DATE CANCEL_REASON SHORTLIST_FLAG BID_STATUS CREATED_BY VENDOR_SITE_ID SUBMIT_STAGE TRADING_PARTNER_ID AUCTION_HEADER_ID AWARD_STATUS NUMBER_PRICE_DECIMALS DISQUALIFY_REASON RATE_DSP BID_EXPIRATION_DATE DRAFT_UNLOCKED_BY BID_NUMBER TYPE_OF_RESPONSE RATE_DATE BID_CURRENCY_CODE DRAFT_UNLOCKED_BY_CONTACT_ID INTERNAL_NOTE VENDOR_SITE_CODE LAST_UPDATED_BY DRAFT_LOCKED_BY MIN_BID_CHANGE RATE_TYPE PO_AGREED_AMOUNT DRAFT_LOCKED_BY_CONTACT_ID TRADING_PARTNER_CONTACT_ID ATTRIBUTE_LINE_NUMBER DRAFT_UNLOCKED_DATE CREATION_DATE VENDOR_ID TOTAL_AWARD_AMOUNT SURROG_BID_CREATED_PERSON_ID SURROG_BID_RECEIPT_DATE SURROG_BID_ONLINE_ENTRY_DATE SURROG_BID_FLAG COLOR_SEQUENCE_ID AWARD_DATE PARTIAL_RESPONSE_FLAG INCUMBENT_FLAG SCORE_OVERRIDEN_FLAG SCORE_OVERRIDEN_DATE REQUEST_ID REQUEST_DATE REQUESTED_BY IMPORT_FILE_NAME OLD_NOTE_TO_AUCTION_OWNER OLD_BIDDERS_BID_NUMBER OLD_BID_EXPIRATION_DATE OLD_BID_STATUS OLD_MIN_BID_CHANGE OLD_SURROG_BID_RECEIPT_DATE SURROG_METHOD_OF_RESPONSE DISPLAY_PRICE_FACTORS_FLAG OLD_BID_NUMBER BUYER_BID_TOTAL SHORTLIST_BUYER_ID CURRENT_TOTAL_SPEND FIXED_INCENTIVE CURRENT_REBATE HAS_REBATE_TIERS OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN PROGRAM_NAME PROGRAM_APP_NAME TECHNICAL_SHORTLIST_FLAG BID_CURRENCY_MIN_BID_CHANGE OLD_BID_CURR_MIN_BID_CHANGE SURROG_DRAFT_LOCK_PERSON_ID SURROG_DRAFT_UNLOCK_PERSON_ID MAX_INTERNAL_LINE_NUM ORIGINAL_BID_NUMBER POQ_TRANSFER_STATUS SCORING_STATUS TECHNICAL_SCORING_STATUS SCORE_OVERRIDE_REASON SCORE_OVERRIDE_PERSON_ID OVERRIDEN_SCORE BUYER_BID_TRANSFORMED_TOTAL TRANSFORMED_RANK CONTRACT_ID CONTRACT_LINES_FLAG CONTRACT_ERROR_MSG ACTION_CODE SOURCE_BID_NUMBER JOB_PARAMS HAS_LINES_INSERTED_FLAG PRE_BID_FLAG RELATIVE_SCORE OVERALL_RANK

Name

LAST_UPDATE_DATE

NOTE_TO_AUCTION_OWNER

RATE

NOTE_TO_SUPPLIER

DRAFT_LOCKED_DATE

BIDDERS_BID_NUMBER

CANCELLED_DATE

PROXY_BID_FLAG

DRAFT_LOCKED

PUBLISH_DATE

CANCEL_REASON

SHORTLIST_FLAG

BID_STATUS

CREATED_BY

VENDOR_SITE_ID

SUBMIT_STAGE

TRADING_PARTNER_ID

AUCTION_HEADER_ID

AWARD_STATUS

NUMBER_PRICE_DECIMALS

DISQUALIFY_REASON

RATE_DSP

BID_EXPIRATION_DATE

DRAFT_UNLOCKED_BY

BID_NUMBER

TYPE_OF_RESPONSE

RATE_DATE

BID_CURRENCY_CODE

DRAFT_UNLOCKED_BY_CONTACT_ID

INTERNAL_NOTE

VENDOR_SITE_CODE

LAST_UPDATED_BY

DRAFT_LOCKED_BY

MIN_BID_CHANGE

RATE_TYPE

PO_AGREED_AMOUNT

DRAFT_LOCKED_BY_CONTACT_ID

TRADING_PARTNER_CONTACT_ID

ATTRIBUTE_LINE_NUMBER

DRAFT_UNLOCKED_DATE

CREATION_DATE

VENDOR_ID

TOTAL_AWARD_AMOUNT

SURROG_BID_CREATED_PERSON_ID

SURROG_BID_RECEIPT_DATE

SURROG_BID_ONLINE_ENTRY_DATE

SURROG_BID_FLAG

COLOR_SEQUENCE_ID

AWARD_DATE

PARTIAL_RESPONSE_FLAG

INCUMBENT_FLAG

SCORE_OVERRIDEN_FLAG

SCORE_OVERRIDEN_DATE

REQUEST_ID

REQUEST_DATE

REQUESTED_BY

IMPORT_FILE_NAME

OLD_NOTE_TO_AUCTION_OWNER

OLD_BIDDERS_BID_NUMBER

OLD_BID_EXPIRATION_DATE

OLD_BID_STATUS

OLD_MIN_BID_CHANGE

OLD_SURROG_BID_RECEIPT_DATE

SURROG_METHOD_OF_RESPONSE

DISPLAY_PRICE_FACTORS_FLAG

OLD_BID_NUMBER

BUYER_BID_TOTAL

SHORTLIST_BUYER_ID

CURRENT_TOTAL_SPEND

FIXED_INCENTIVE

CURRENT_REBATE

HAS_REBATE_TIERS

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

PROGRAM_NAME

PROGRAM_APP_NAME

TECHNICAL_SHORTLIST_FLAG

BID_CURRENCY_MIN_BID_CHANGE

OLD_BID_CURR_MIN_BID_CHANGE

SURROG_DRAFT_LOCK_PERSON_ID

SURROG_DRAFT_UNLOCK_PERSON_ID

MAX_INTERNAL_LINE_NUM

ORIGINAL_BID_NUMBER

POQ_TRANSFER_STATUS

SCORING_STATUS

TECHNICAL_SCORING_STATUS

SCORE_OVERRIDE_REASON

SCORE_OVERRIDE_PERSON_ID

OVERRIDEN_SCORE

BUYER_BID_TRANSFORMED_TOTAL

TRANSFORMED_RANK

CONTRACT_ID

CONTRACT_LINES_FLAG

CONTRACT_ERROR_MSG

ACTION_CODE

SOURCE_BID_NUMBER

JOB_PARAMS

HAS_LINES_INSERTED_FLAG

PRE_BID_FLAG

RELATIVE_SCORE

OVERALL_RANK

Query

SQL_Statement
SELECT pbh.LAST_UPDATE_DATE LAST_UPDATE_DATE, NVL2(pbh.NOTE_TO_AUCTION_OWNER, 'Secure', NULL) NOTE_TO_AUCTION_OWNER, pbh.RATE RATE, NVL2(pbh.NOTE_TO_SUPPLIER, 'Secure', NULL) NOTE_TO_SUPPLIER, pbh.DRAFT_LOCKED_DATE DRAFT_LOCKED_DATE, pbh.BIDDERS_BID_NUMBER BIDDERS_BID_NUMBER, pbh.CANCELLED_DATE CANCELLED_DATE, pbh.PROXY_BID_FLAG PROXY_BID_FLAG, pbh.DRAFT_LOCKED DRAFT_LOCKED, pbh.PUBLISH_DATE PUBLISH_DATE, NVL2(pbh.CANCEL_REASON, 'Secure', NULL) CANCEL_REASON, pbh.SHORTLIST_FLAG SHORTLIST_FLAG, pbh.BID_STATUS BID_STATUS, pbh.CREATED_BY CREATED_BY, pbh.VENDOR_SITE_ID VENDOR_SITE_ID, pbh.SUBMIT_STAGE SUBMIT_STAGE, pbh.TRADING_PARTNER_ID TRADING_PARTNER_ID, pbh.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbh.AWARD_STATUS AWARD_STATUS, pbh.NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS, NVL2(pbh.DISQUALIFY_REASON, 'Secure', NULL) DISQUALIFY_REASON, pbh.RATE_DSP RATE_DSP, pbh.BID_EXPIRATION_DATE BID_EXPIRATION_DATE, pbh.DRAFT_UNLOCKED_BY DRAFT_UNLOCKED_BY, pbh.BID_NUMBER BID_NUMBER, pbh.TYPE_OF_RESPONSE TYPE_OF_RESPONSE, pbh.RATE_DATE RATE_DATE, pbh.BID_CURRENCY_CODE BID_CURRENCY_CODE, pbh.DRAFT_UNLOCKED_BY_CONTACT_ID DRAFT_UNLOCKED_BY_CONTACT_ID, NVL2(pbh.INTERNAL_NOTE, 'Secure', NULL) INTERNAL_NOTE, pbh.VENDOR_SITE_CODE VENDOR_SITE_CODE, pbh.LAST_UPDATED_BY LAST_UPDATED_BY, pbh.DRAFT_LOCKED_BY DRAFT_LOCKED_BY, pbh.MIN_BID_CHANGE MIN_BID_CHANGE, pbh.RATE_TYPE RATE_TYPE, pbh.PO_AGREED_AMOUNT PO_AGREED_AMOUNT, pbh.DRAFT_LOCKED_BY_CONTACT_ID DRAFT_LOCKED_BY_CONTACT_ID, pbh.TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID, pbh.ATTRIBUTE_LINE_NUMBER ATTRIBUTE_LINE_NUMBER, pbh.DRAFT_UNLOCKED_DATE DRAFT_UNLOCKED_DATE, pbh.CREATION_DATE CREATION_DATE, pbh.VENDOR_ID VENDOR_ID, pbh.TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT, pbh.SURROG_BID_CREATED_PERSON_ID SURROG_BID_CREATED_PERSON_ID, pbh.SURROG_BID_RECEIPT_DATE SURROG_BID_RECEIPT_DATE, pbh.SURROG_BID_ONLINE_ENTRY_DATE SURROG_BID_ONLINE_ENTRY_DATE, pbh.SURROG_BID_FLAG SURROG_BID_FLAG, pbh.COLOR_SEQUENCE_ID COLOR_SEQUENCE_ID, pbh.AWARD_DATE AWARD_DATE, pbh.PARTIAL_RESPONSE_FLAG PARTIAL_RESPONSE_FLAG, pbh.INCUMBENT_FLAG INCUMBENT_FLAG, pbh.SCORE_OVERRIDEN_FLAG SCORE_OVERRIDEN_FLAG, pbh.SCORE_OVERRIDEN_DATE SCORE_OVERRIDEN_DATE, pbh.REQUEST_ID REQUEST_ID, pbh.REQUEST_DATE REQUEST_DATE, pbh.REQUESTED_BY REQUESTED_BY, pbh.IMPORT_FILE_NAME IMPORT_FILE_NAME, NVL2(pbh.OLD_NOTE_TO_AUCTION_OWNER, 'Secure', NULL) OLD_NOTE_TO_AUCTION_OWNER, pbh.OLD_BIDDERS_BID_NUMBER OLD_BIDDERS_BID_NUMBER, pbh.OLD_BID_EXPIRATION_DATE OLD_BID_EXPIRATION_DATE, pbh.OLD_BID_STATUS OLD_BID_STATUS, pbh.OLD_MIN_BID_CHANGE OLD_MIN_BID_CHANGE, pbh.OLD_SURROG_BID_RECEIPT_DATE OLD_SURROG_BID_RECEIPT_DATE, pbh.SURROG_METHOD_OF_RESPONSE SURROG_METHOD_OF_RESPONSE, pbh.DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG, pbh.OLD_BID_NUMBER OLD_BID_NUMBER, pbh.BUYER_BID_TOTAL BUYER_BID_TOTAL, pbh.SHORTLIST_BUYER_ID SHORTLIST_BUYER_ID, pbh.CURRENT_TOTAL_SPEND CURRENT_TOTAL_SPEND, pbh.FIXED_INCENTIVE FIXED_INCENTIVE, pbh.CURRENT_REBATE CURRENT_REBATE, pbh.HAS_REBATE_TIERS HAS_REBATE_TIERS, pbh.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbh.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbh.PROGRAM_NAME PROGRAM_NAME, pbh.PROGRAM_APP_NAME PROGRAM_APP_NAME, pbh.TECHNICAL_SHORTLIST_FLAG TECHNICAL_SHORTLIST_FLAG, pbh.BID_CURRENCY_MIN_BID_CHANGE BID_CURRENCY_MIN_BID_CHANGE, pbh.OLD_BID_CURR_MIN_BID_CHANGE OLD_BID_CURR_MIN_BID_CHANGE, pbh.SURROG_DRAFT_LOCK_PERSON_ID SURROG_DRAFT_LOCK_PERSON_ID, pbh.SURROG_DRAFT_UNLOCK_PERSON_ID SURROG_DRAFT_UNLOCK_PERSON_ID, pbh.MAX_INTERNAL_LINE_NUM MAX_INTERNAL_LINE_NUM, pbh.ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER, pbh.POQ_TRANSFER_STATUS POQ_TRANSFER_STATUS, pbh.SCORING_STATUS SCORING_STATUS, pbh.TECHNICAL_SCORING_STATUS TECHNICAL_SCORING_STATUS, pbh.SCORE_OVERRIDE_REASON SCORE_OVERRIDE_REASON, pbh.SCORE_OVERRIDE_PERSON_ID SCORE_OVERRIDE_PERSON_ID, pbh.OVERRIDEN_SCORE OVERRIDEN_SCORE, pbh.BUYER_BID_TRANSFORMED_TOTAL BUYER_BID_TRANSFORMED_TOTAL, pbh.TRANSFORMED_RANK TRANSFORMED_RANK, pbh.CONTRACT_ID CONTRACT_ID, pbh.CONTRACT_LINES_FLAG, pbh.CONTRACT_ERROR_MSG, pbh.ACTION_CODE, pbh.SOURCE_BID_NUMBER, pbh.JOB_PARAMS, pbh.HAS_LINES_INSERTED_FLAG, pbh.PRE_BID_FLAG, pbh.RELATIVE_SCORE, pbh.OVERALL_RANK FROM PON_BID_HEADERS pbh, PON_AUCTION_HEADERS_ALL pah WHERE pbh.AUCTION_HEADER_ID = pah.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))

SQL_Statement

SELECT

pbh.LAST_UPDATE_DATE LAST_UPDATE_DATE,

NVL2(pbh.NOTE_TO_AUCTION_OWNER, 'Secure', NULL) NOTE_TO_AUCTION_OWNER,

pbh.RATE RATE,

NVL2(pbh.NOTE_TO_SUPPLIER, 'Secure', NULL) NOTE_TO_SUPPLIER,

pbh.DRAFT_LOCKED_DATE DRAFT_LOCKED_DATE,

pbh.BIDDERS_BID_NUMBER BIDDERS_BID_NUMBER,

pbh.CANCELLED_DATE CANCELLED_DATE,

pbh.PROXY_BID_FLAG PROXY_BID_FLAG,

pbh.DRAFT_LOCKED DRAFT_LOCKED,

pbh.PUBLISH_DATE PUBLISH_DATE,

NVL2(pbh.CANCEL_REASON, 'Secure', NULL) CANCEL_REASON,

pbh.SHORTLIST_FLAG SHORTLIST_FLAG,

pbh.BID_STATUS BID_STATUS,

pbh.CREATED_BY CREATED_BY,

pbh.VENDOR_SITE_ID VENDOR_SITE_ID,

pbh.SUBMIT_STAGE SUBMIT_STAGE,

pbh.TRADING_PARTNER_ID TRADING_PARTNER_ID,

pbh.AUCTION_HEADER_ID AUCTION_HEADER_ID,

pbh.AWARD_STATUS AWARD_STATUS,

pbh.NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS,

NVL2(pbh.DISQUALIFY_REASON, 'Secure', NULL) DISQUALIFY_REASON,

pbh.RATE_DSP RATE_DSP,

pbh.BID_EXPIRATION_DATE BID_EXPIRATION_DATE,

pbh.DRAFT_UNLOCKED_BY DRAFT_UNLOCKED_BY,

pbh.BID_NUMBER BID_NUMBER,

pbh.TYPE_OF_RESPONSE TYPE_OF_RESPONSE,

pbh.RATE_DATE RATE_DATE,

pbh.BID_CURRENCY_CODE BID_CURRENCY_CODE,

pbh.DRAFT_UNLOCKED_BY_CONTACT_ID DRAFT_UNLOCKED_BY_CONTACT_ID,

NVL2(pbh.INTERNAL_NOTE, 'Secure', NULL) INTERNAL_NOTE,

pbh.VENDOR_SITE_CODE VENDOR_SITE_CODE,

pbh.LAST_UPDATED_BY LAST_UPDATED_BY,

pbh.DRAFT_LOCKED_BY DRAFT_LOCKED_BY,

pbh.MIN_BID_CHANGE MIN_BID_CHANGE,

pbh.RATE_TYPE RATE_TYPE,

pbh.PO_AGREED_AMOUNT PO_AGREED_AMOUNT,

pbh.DRAFT_LOCKED_BY_CONTACT_ID DRAFT_LOCKED_BY_CONTACT_ID,

pbh.TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID,

pbh.ATTRIBUTE_LINE_NUMBER ATTRIBUTE_LINE_NUMBER,

pbh.DRAFT_UNLOCKED_DATE DRAFT_UNLOCKED_DATE,

pbh.CREATION_DATE CREATION_DATE,

pbh.VENDOR_ID VENDOR_ID,

pbh.TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT,

pbh.SURROG_BID_CREATED_PERSON_ID SURROG_BID_CREATED_PERSON_ID,

pbh.SURROG_BID_RECEIPT_DATE SURROG_BID_RECEIPT_DATE,

pbh.SURROG_BID_ONLINE_ENTRY_DATE SURROG_BID_ONLINE_ENTRY_DATE,

pbh.SURROG_BID_FLAG SURROG_BID_FLAG,

pbh.COLOR_SEQUENCE_ID COLOR_SEQUENCE_ID,

pbh.AWARD_DATE AWARD_DATE,

pbh.PARTIAL_RESPONSE_FLAG PARTIAL_RESPONSE_FLAG,

pbh.INCUMBENT_FLAG INCUMBENT_FLAG,

pbh.SCORE_OVERRIDEN_FLAG SCORE_OVERRIDEN_FLAG,

pbh.SCORE_OVERRIDEN_DATE SCORE_OVERRIDEN_DATE,

pbh.REQUEST_ID REQUEST_ID,

pbh.REQUEST_DATE REQUEST_DATE,

pbh.REQUESTED_BY REQUESTED_BY,

pbh.IMPORT_FILE_NAME IMPORT_FILE_NAME,

NVL2(pbh.OLD_NOTE_TO_AUCTION_OWNER, 'Secure', NULL) OLD_NOTE_TO_AUCTION_OWNER,

pbh.OLD_BIDDERS_BID_NUMBER OLD_BIDDERS_BID_NUMBER,

pbh.OLD_BID_EXPIRATION_DATE OLD_BID_EXPIRATION_DATE,

pbh.OLD_BID_STATUS OLD_BID_STATUS,

pbh.OLD_MIN_BID_CHANGE OLD_MIN_BID_CHANGE,

pbh.OLD_SURROG_BID_RECEIPT_DATE OLD_SURROG_BID_RECEIPT_DATE,

pbh.SURROG_METHOD_OF_RESPONSE SURROG_METHOD_OF_RESPONSE,

pbh.DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG,

pbh.OLD_BID_NUMBER OLD_BID_NUMBER,

pbh.BUYER_BID_TOTAL BUYER_BID_TOTAL,

pbh.SHORTLIST_BUYER_ID SHORTLIST_BUYER_ID,

pbh.CURRENT_TOTAL_SPEND CURRENT_TOTAL_SPEND,

pbh.FIXED_INCENTIVE FIXED_INCENTIVE,

pbh.CURRENT_REBATE CURRENT_REBATE,

pbh.HAS_REBATE_TIERS HAS_REBATE_TIERS,

pbh.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pbh.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pbh.PROGRAM_NAME PROGRAM_NAME,

pbh.PROGRAM_APP_NAME PROGRAM_APP_NAME,

pbh.TECHNICAL_SHORTLIST_FLAG TECHNICAL_SHORTLIST_FLAG,

pbh.BID_CURRENCY_MIN_BID_CHANGE BID_CURRENCY_MIN_BID_CHANGE,

pbh.OLD_BID_CURR_MIN_BID_CHANGE OLD_BID_CURR_MIN_BID_CHANGE,

pbh.SURROG_DRAFT_LOCK_PERSON_ID SURROG_DRAFT_LOCK_PERSON_ID,

pbh.SURROG_DRAFT_UNLOCK_PERSON_ID SURROG_DRAFT_UNLOCK_PERSON_ID,

pbh.MAX_INTERNAL_LINE_NUM MAX_INTERNAL_LINE_NUM,

pbh.ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER,

pbh.POQ_TRANSFER_STATUS POQ_TRANSFER_STATUS,

pbh.SCORING_STATUS SCORING_STATUS,

pbh.TECHNICAL_SCORING_STATUS TECHNICAL_SCORING_STATUS,

pbh.SCORE_OVERRIDE_REASON SCORE_OVERRIDE_REASON,

pbh.SCORE_OVERRIDE_PERSON_ID SCORE_OVERRIDE_PERSON_ID,

pbh.OVERRIDEN_SCORE OVERRIDEN_SCORE,

pbh.BUYER_BID_TRANSFORMED_TOTAL BUYER_BID_TRANSFORMED_TOTAL,

pbh.TRANSFORMED_RANK TRANSFORMED_RANK,

pbh.CONTRACT_ID CONTRACT_ID,

pbh.CONTRACT_LINES_FLAG,

pbh.CONTRACT_ERROR_MSG,

pbh.ACTION_CODE,

pbh.SOURCE_BID_NUMBER,

pbh.JOB_PARAMS,

pbh.HAS_LINES_INSERTED_FLAG,

pbh.PRE_BID_FLAG,

pbh.RELATIVE_SCORE,

pbh.OVERALL_RANK

FROM

PON_BID_HEADERS pbh,

PON_AUCTION_HEADERS_ALL pah

WHERE

pbh.AUCTION_HEADER_ID = pah.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))