[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000524059C00008$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | 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 |
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;
PON.PON_FBO_POSTS does not reference any database object
PON.PON_FBO_POSTS is referenced by following:
|
|
|