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_SUPPLIER_ACCESS

Object Details

Object Name:	PON_SUPPLIER_ACCESS
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_SUPPLIER_ACCESS
Subobject Name:
Status:	VALID

PON_SUPPLIER_ACCESS will record the lock status for a supplier.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_SUPPLIER_ACCESS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID_ORIG_AMEND SUPPLIER_TRADING_PARTNER_ID LOCK_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID_ORIG_AMEND	NUMBER		Yes	Contains the identifier of the first negotiation in a series of amendments. If this is the first in the series, then it is the same as the identifier of the negotiation.
SUPPLIER_TRADING_PARTNER_ID	NUMBER		Yes	Identifier of the Supplier who is being locked or granted access.
LOCK_DATE	DATE		Yes	Date and time on which the supplier was locked or granted access to the negotiation.
BUYER_TP_CONTACT_ID	NUMBER		Yes	Identifier of the buyer who performed the action of locking or granting access.
LOCK_STATUS	VARCHAR2	(8)	Yes	Flag indicating if the supplier is locked from the negotiation or not. LOCK - indicates supplier is locked. UNLOCK - indicates supplier has been granted access.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates the most current record. Earlier records for the same supplier will have an 'N'.
AUCTION_HEADER_ID	NUMBER		Yes	Identifier of the negotiation where the lock was initiated.
LOCK_REASON	VARCHAR2	(4000)		Free-form reason entered by the Buyer when performing the lock or grant action.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUCTION_HEADER_ID_ORIG_AMEND
,      SUPPLIER_TRADING_PARTNER_ID
,      LOCK_DATE
,      BUYER_TP_CONTACT_ID
,      LOCK_STATUS
,      ACTIVE_FLAG
,      AUCTION_HEADER_ID
,      LOCK_REASON
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PON.PON_SUPPLIER_ACCESS;

Dependencies

[top of page]

PON.PON_SUPPLIER_ACCESS does not reference any database object

PON.PON_SUPPLIER_ACCESS is referenced by following:

APPS: PON_SUPPLIER_ACCESS