eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PON.PON_AUCTION_HEADERS_INTERFACE

Object Details

Object Name:	PON_AUCTION_HEADERS_INTERFACE
Object Type:	TABLE
Owner:	PON
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000873935C00148$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

PON.PON_AUCTION_HEADERS_INTERFACE does not reference any database object

PON.PON_AUCTION_HEADERS_INTERFACE is referenced by following:

PON: PON_AUCTION_HEADERS_INTERFACE#