[Home] [Help] [Dependency Information]
Object Name: | PON_AUCTION_HEADERS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | PON |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000873935C00148$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_BATCH_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | ||
DOCUMENT_NUMBER | VARCHAR2 | (240) | ||
AUCTION_TITLE | VARCHAR2 | (80) | ||
DESCRIPTION | VARCHAR2 | (250) | ||
AUCTION_TYPE | VARCHAR2 | (25) | ||
ORG_ID | NUMBER | |||
CONTRACT_TYPE | VARCHAR2 | (25) | ||
EVENT_ID | NUMBER | |||
EVENT_TITLE | VARCHAR2 | (80) | ||
SECURITY_LEVEL_CODE | VARCHAR2 | (25) | ||
PO_AGREED_AMOUNT | NUMBER | |||
PO_MIN_REL_AMOUNT | NUMBER | |||
GLOBAL_AGREEMENT_FLAG | VARCHAR2 | (1) | ||
PO_START_DATE | DATE | |||
PO_END_DATE | DATE | |||
SHIP_TO_LOCATION_CODE | VARCHAR2 | (80) | ||
SHIP_TO_LOCATION_ID | NUMBER | |||
BILL_TO_LOCATION_CODE | VARCHAR2 | (80) | ||
BILL_TO_LOCATION_ID | NUMBER | |||
PAYMENT_TERMS_ID | NUMBER | |||
FOB_CODE | VARCHAR2 | (25) | ||
CARRIER_CODE | VARCHAR2 | (25) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE_TYPE | VARCHAR2 | (25) | ||
RATE_DATE | DATE | |||
PUBLISH_RATES_TO_BIDDERS_FLAG | VARCHAR2 | (1) | ||
OPEN_BIDDING_DATE | DATE | |||
CLOSE_BIDDING_DATE | DATE | |||
VIEW_BY_DATE | DATE | |||
AWARD_BY_DATE | DATE | |||
PUBLISH_DATE | DATE | |||
OPEN_AUCTION_NOW_FLAG | VARCHAR2 | (1) | ||
PUBLISH_AUCTION_NOW_FLAG | VARCHAR2 | (1) | ||
NOTE_TO_BIDDERS | VARCHAR2 | (4000) | ||
SHOW_BIDDER_NOTES | VARCHAR2 | (1) | ||
BID_VISIBILITY_CODE | VARCHAR2 | (25) | ||
BID_SCOPE_CODE | VARCHAR2 | (25) | ||
BID_LIST_TYPE | VARCHAR2 | (25) | ||
BID_FREQUENCY_CODE | VARCHAR2 | (25) | ||
BID_RANKING | VARCHAR2 | (25) | ||
RANK_INDICATOR | VARCHAR2 | (25) | ||
FULL_QUANTITY_BID_CODE | VARCHAR2 | (25) | ||
MULTIPLE_ROUNDS_FLAG | VARCHAR2 | (1) | ||
MANUAL_CLOSE_FLAG | VARCHAR2 | (1) | ||
MANUAL_EXTEND_FLAG | VARCHAR2 | (1) | ||
AWARD_APPROVAL_FLAG | VARCHAR2 | (1) | ||
AUCTION_ORIGINATION_CODE | VARCHAR2 | (50) | ||
DOCTYPE_ID | NUMBER | |||
BUYER_ID | NUMBER | |||
STYLE_ID | NUMBER | |||
PO_STYLE_ID | NUMBER | |||
ADVANCE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
RECOUPMENT_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
PROGRESS_PYMT_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
MAX_RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
SUPPLIER_ENTERABLE_PYMT_FLAG | VARCHAR2 | (1) | ||
TWO_PART_FLAG | VARCHAR2 | (1) | ||
PROJECT_ID | NUMBER | |||
PF_TYPE_ALLOWED | VARCHAR2 | (30) | ||
PRICE_BREAK_RESPONSE | VARCHAR2 | (25) | ||
PRICE_TIERS_INDICATOR | VARCHAR2 | (30) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
INT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
INT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
INT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
EXT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
EXT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
EFFECTIVE_DATE | DATE | |||
SIGNED_DATE | DATE | |||
AMENDMENT_FLAG | VARCHAR2 | (1) | ||
SOLICITATION_TYPE | VARCHAR2 | (50) | ||
UDA_TEMPLATE_ID | NUMBER | |||
UDA_TEMPLATE_DATE | DATE | |||
NO_OF_COPIES | NUMBER | |||
PO_STYLE_NAME | VARCHAR2 | (240) | ||
AMENDMENT_DESCRIPTION | VARCHAR2 | (4000) | ||
STANDARD_FORM | VARCHAR2 | (240) | ||
DOCUMENT_FORMAT | VARCHAR2 | (240) | ||
AUTO_EXTEND_MIN_TRIGGER_RANK | NUMBER | |||
ENFORCE_PREVRND_BID_PRICE_FLAG | VARCHAR2 | (1) | ||
STAGGERED_CLOSING_INTERVAL | NUMBER | |||
FIRST_LINE_CLOSE_DATE | DATE | |||
DISPLAY_BEST_PRICE_BLIND_FLAG | VARCHAR2 | (1) | ||
BID_DECREMENT_METHOD | VARCHAR2 | (15) | ||
SUPPLIER_VIEW_TYPE | VARCHAR2 | (40) | ||
ABSTRACT_DETAILS | VARCHAR2 | (4000) | ||
HDR_ATTR_DISPLAY_SCORE | VARCHAR2 | (1) | ||
PROGRESS_PAYMENT_TYPE | VARCHAR2 | (10) | ||
LINE_MAS_ENABLED_FLAG | VARCHAR2 | (1) | ||
HDR_ATTR_ENABLE_WEIGHTS | VARCHAR2 | (1) | ||
AUTO_EXTEND_FLAG | VARCHAR2 | (1) | ||
AUTO_EXTEND_NUMBER | NUMBER | |||
MIN_BID_DECREMENT | NUMBER | |||
MIN_BID_CHANGE_TYPE | VARCHAR2 | (25) | ||
PRICE_DRIVEN_AUCTION_FLAG | VARCHAR2 | (1) | ||
AUTO_EXTEND_ALL_LINES_FLAG | VARCHAR2 | (1) | ||
ALLOW_OTHER_BID_CURRENCY_FLAG | VARCHAR2 | (1) | ||
AUTO_EXTEND_DURATION | NUMBER | |||
SEALED_AUCTION_STATUS | VARCHAR2 | (30) | ||
AUTO_EXTEND_TYPE_FLAG | VARCHAR2 | (50) | ||
SHOW_BIDDER_SCORES | VARCHAR2 | (25) | ||
AUCTION_HEADER_ID | NUMBER | |||
RETAIN_CLAUSE_FLAG | VARCHAR2 | (1) | ||
UPDATE_CLAUSE_FLAG | VARCHAR2 | (1) | ||
RETAIN_ATTACHMENTS_FLAG | VARCHAR2 | (1) | ||
ALLOW_MULTIPLE_ACTIVE_OFFERS | VARCHAR2 | (1) | ||
ALLOW_UNSOL_OFFER_LINES | VARCHAR2 | (1) | ||
ALLOW_WITHDRAW_FLAG | VARCHAR2 | (1) | ||
AMENDUPDATED_AFTERCDGENERATED | VARCHAR2 | (1) | ||
CANCEL_AMENDMENT | VARCHAR2 | (1) | ||
CD_EDITBYUSER_FLAG | VARCHAR2 | (1) | ||
CD_GENERATED_DATE | DATE | |||
CD_GENERATED_FLAG | VARCHAR2 | (1) | ||
CHANGEDESCRIPTION_DATA | CLOB | (4000) | ||
FAIR_OPP_NOTICE_FLAG | VARCHAR2 | (1) | ||
FEDERAL_PUBLICATION_EXCEPTION | VARCHAR2 | (30) | ||
REVISION | NUMBER | |||
UMBRELLA_PROGRAM_ID | NUMBER | |||
AUCTION_PUBLISHED_FLAG | VARCHAR2 | (1) | ||
INTERFACE_HEADER_ID | NUMBER | |||
INTERFACE_GROUP_ID | NUMBER | |||
TRADING_PARTNER_CONTACT_NAME | VARCHAR2 | (255) | ||
FREIGHT_TERMS_CODE#1 | VARCHAR2 | (30) | Freight Terms Code |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_BATCH_ID
, BATCH_ID
, PROCESSING_STATUS_CODE
, DOCUMENT_NUMBER
, AUCTION_TITLE
, DESCRIPTION
, AUCTION_TYPE
, ORG_ID
, CONTRACT_TYPE
, EVENT_ID
, EVENT_TITLE
, SECURITY_LEVEL_CODE
, PO_AGREED_AMOUNT
, PO_MIN_REL_AMOUNT
, GLOBAL_AGREEMENT_FLAG
, PO_START_DATE
, PO_END_DATE
, SHIP_TO_LOCATION_CODE
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_CODE
, BILL_TO_LOCATION_ID
, PAYMENT_TERMS_ID
, FOB_CODE
, CARRIER_CODE
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, PUBLISH_RATES_TO_BIDDERS_FLAG
, OPEN_BIDDING_DATE
, CLOSE_BIDDING_DATE
, VIEW_BY_DATE
, AWARD_BY_DATE
, PUBLISH_DATE
, OPEN_AUCTION_NOW_FLAG
, PUBLISH_AUCTION_NOW_FLAG
, NOTE_TO_BIDDERS
, SHOW_BIDDER_NOTES
, BID_VISIBILITY_CODE
, BID_SCOPE_CODE
, BID_LIST_TYPE
, BID_FREQUENCY_CODE
, BID_RANKING
, RANK_INDICATOR
, FULL_QUANTITY_BID_CODE
, MULTIPLE_ROUNDS_FLAG
, MANUAL_CLOSE_FLAG
, MANUAL_EXTEND_FLAG
, AWARD_APPROVAL_FLAG
, AUCTION_ORIGINATION_CODE
, DOCTYPE_ID
, BUYER_ID
, STYLE_ID
, PO_STYLE_ID
, ADVANCE_NEGOTIABLE_FLAG
, RECOUPMENT_NEGOTIABLE_FLAG
, PROGRESS_PYMT_NEGOTIABLE_FLAG
, RETAINAGE_NEGOTIABLE_FLAG
, MAX_RETAINAGE_NEGOTIABLE_FLAG
, SUPPLIER_ENTERABLE_PYMT_FLAG
, TWO_PART_FLAG
, PROJECT_ID
, PF_TYPE_ALLOWED
, PRICE_BREAK_RESPONSE
, PRICE_TIERS_INDICATOR
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, INT_ATTRIBUTE_CATEGORY
, INT_ATTRIBUTE1
, INT_ATTRIBUTE2
, INT_ATTRIBUTE3
, INT_ATTRIBUTE4
, INT_ATTRIBUTE5
, INT_ATTRIBUTE6
, INT_ATTRIBUTE7
, INT_ATTRIBUTE8
, INT_ATTRIBUTE9
, INT_ATTRIBUTE10
, INT_ATTRIBUTE11
, INT_ATTRIBUTE12
, INT_ATTRIBUTE13
, INT_ATTRIBUTE14
, INT_ATTRIBUTE15
, EXT_ATTRIBUTE_CATEGORY
, EXT_ATTRIBUTE1
, EXT_ATTRIBUTE2
, EXT_ATTRIBUTE3
, EXT_ATTRIBUTE4
, EXT_ATTRIBUTE5
, EXT_ATTRIBUTE6
, EXT_ATTRIBUTE7
, EXT_ATTRIBUTE8
, EXT_ATTRIBUTE9
, EXT_ATTRIBUTE10
, EXT_ATTRIBUTE11
, EXT_ATTRIBUTE12
, EXT_ATTRIBUTE13
, EXT_ATTRIBUTE14
, EXT_ATTRIBUTE15
, EFFECTIVE_DATE
, SIGNED_DATE
, AMENDMENT_FLAG
, SOLICITATION_TYPE
, UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE
, NO_OF_COPIES
, PO_STYLE_NAME
, AMENDMENT_DESCRIPTION
, STANDARD_FORM
, DOCUMENT_FORMAT
, AUTO_EXTEND_MIN_TRIGGER_RANK
, ENFORCE_PREVRND_BID_PRICE_FLAG
, STAGGERED_CLOSING_INTERVAL
, FIRST_LINE_CLOSE_DATE
, DISPLAY_BEST_PRICE_BLIND_FLAG
, BID_DECREMENT_METHOD
, SUPPLIER_VIEW_TYPE
, ABSTRACT_DETAILS
, HDR_ATTR_DISPLAY_SCORE
, PROGRESS_PAYMENT_TYPE
, LINE_MAS_ENABLED_FLAG
, HDR_ATTR_ENABLE_WEIGHTS
, AUTO_EXTEND_FLAG
, AUTO_EXTEND_NUMBER
, MIN_BID_DECREMENT
, MIN_BID_CHANGE_TYPE
, PRICE_DRIVEN_AUCTION_FLAG
, AUTO_EXTEND_ALL_LINES_FLAG
, ALLOW_OTHER_BID_CURRENCY_FLAG
, AUTO_EXTEND_DURATION
, SEALED_AUCTION_STATUS
, AUTO_EXTEND_TYPE_FLAG
, SHOW_BIDDER_SCORES
, AUCTION_HEADER_ID
, RETAIN_CLAUSE_FLAG
, UPDATE_CLAUSE_FLAG
, RETAIN_ATTACHMENTS_FLAG
, ALLOW_MULTIPLE_ACTIVE_OFFERS
, ALLOW_UNSOL_OFFER_LINES
, ALLOW_WITHDRAW_FLAG
, AMENDUPDATED_AFTERCDGENERATED
, CANCEL_AMENDMENT
, CD_EDITBYUSER_FLAG
, CD_GENERATED_DATE
, CD_GENERATED_FLAG
, CHANGEDESCRIPTION_DATA
, FAIR_OPP_NOTICE_FLAG
, FEDERAL_PUBLICATION_EXCEPTION
, REVISION
, UMBRELLA_PROGRAM_ID
, AUCTION_PUBLISHED_FLAG
, INTERFACE_HEADER_ID
, INTERFACE_GROUP_ID
, TRADING_PARTNER_CONTACT_NAME
, FREIGHT_TERMS_CODE#1
FROM PON.PON_AUCTION_HEADERS_INTERFACE;
PON.PON_AUCTION_HEADERS_INTERFACE does not reference any database object
PON.PON_AUCTION_HEADERS_INTERFACE is referenced by following:
|
|
|