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_FBO_POSTS

Object Details

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

This will store history of notice posted to FedBizOpps

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000524059C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Comments
TRANSACTION_ID	NUMBER		Unique value for each record
DOCUMENT_ID	NUMBER		Auction_Header_id or po_header_id
FORM_ID	NUMBER		Form Id in pon_forms_sections table
FORM_CODE	VARCHAR2	(100)	Form code
PRODUCT_CODE	VARCHAR2	(10)	PO or PON
CP_REQUEST_ID	NUMBER		Concurrent Program Request ID
XML_REQUEST_DATE	DATE		Date when FBO post action performed
XML_DATA	CLOB	(4000)	XML generated for FedBizOpps post
FBO_POST_STATUS	VARCHAR2	(50)	Status returned from FedBizOpps
FBO_POST_DATE	DATE		Response date from FedBizOpps
CREATION_DATE	DATE		WHO column
CREATED_BY	NUMBER		WHO column
LAST_UPDATE_DATE	DATE		WHO column
LAST_UPDATED_BY	NUMBER		WHO column

Query Text

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


SELECT TRANSACTION_ID
,      DOCUMENT_ID
,      FORM_ID
,      FORM_CODE
,      PRODUCT_CODE
,      CP_REQUEST_ID
,      XML_REQUEST_DATE
,      XML_DATA
,      FBO_POST_STATUS
,      FBO_POST_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PON.PON_FBO_POSTS;

Dependencies

[top of page]

PON.PON_FBO_POSTS does not reference any database object

PON.PON_FBO_POSTS is referenced by following:

PON: PON_FBO_POSTS#