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]

VIEW: PON.PON_BID_ITEM_PRICES_INTERFACE#

Object Details

Object Name:	PON_BID_ITEM_PRICES_INTERFACE#
Object Type:	VIEW
Owner:	PON
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER		Yes
INTERFACE_LINE_ID	NUMBER		Yes
AUCTION_HEADER_ID	NUMBER		Yes
BID_NUMBER	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
QUANTITY	NUMBER
BID_CURRENCY_PRICE	NUMBER
NOTE_TO_AUCTION_OWNER	VARCHAR2	(4000)
PROMISED_DATE	DATE
BID_CURRENCY_LIMIT_PRICE	NUMBER
ATTACHMENT_DESC	VARCHAR2	(255)
ATTACHMENT_URL	VARCHAR2	(255)
PO_BID_MIN_REL_AMOUNT	NUMBER
BID_CURR_ADVANCE_AMOUNT	NUMBER
RECOUPMENT_RATE_PERCENT	NUMBER
PROGRESS_PYMT_RATE_PERCENT	NUMBER
RETAINAGE_RATE_PERCENT	NUMBER
BID_CURR_MAX_RETAINAGE_AMT	NUMBER
DOCUMENT_DISP_LINE_NUMBER	VARCHAR2	(25)
WORKSHEET_NAME	VARCHAR2	(80)
WORKSHEET_SEQUENCE_NUMBER	NUMBER
PROMISE_POP_START_DATE	DATE
PROMISE_POP_END_DATE	DATE
CLM_PROMISE_PERIOD	NUMBER
CLM_PROMISE_PERIOD_UOM	VARCHAR2	(80)
CLM_PROMISE_PERIOD_UOM_CODE	VARCHAR2	(25)
CLM_PROMISE_POP_DURATION	NUMBER
CLM_PROMISE_POP_DURATION_UOM	VARCHAR2	(80)
CLM_PROMISE_POP_DUR_UOM_CODE	VARCHAR2	(25)

Query Text

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


SELECT BATCH_ID
,      INTERFACE_LINE_ID
,      AUCTION_HEADER_ID
,      BID_NUMBER
,      LINE_NUMBER
,      QUANTITY
,      BID_CURRENCY_PRICE
,      NOTE_TO_AUCTION_OWNER
,      PROMISED_DATE
,      BID_CURRENCY_LIMIT_PRICE
,      ATTACHMENT_DESC
,      ATTACHMENT_URL
,      PO_BID_MIN_REL_AMOUNT
,      BID_CURR_ADVANCE_AMOUNT
,      RECOUPMENT_RATE_PERCENT
,      PROGRESS_PYMT_RATE_PERCENT
,      RETAINAGE_RATE_PERCENT
,      BID_CURR_MAX_RETAINAGE_AMT
,      DOCUMENT_DISP_LINE_NUMBER
,      WORKSHEET_NAME
,      WORKSHEET_SEQUENCE_NUMBER
,      PROMISE_POP_START_DATE
,      PROMISE_POP_END_DATE
,      CLM_PROMISE_PERIOD
,      CLM_PROMISE_PERIOD_UOM
,      CLM_PROMISE_PERIOD_UOM_CODE
,      CLM_PROMISE_POP_DURATION
,      CLM_PROMISE_POP_DURATION_UOM
,      CLM_PROMISE_POP_DUR_UOM_CODE
FROM PON.PON_BID_ITEM_PRICES_INTERFACE#;

Dependencies

[top of page]

PON.PON_BID_ITEM_PRICES_INTERFACE# references the following:

PON: PON_BID_ITEM_PRICES_INTERFACE

PON.PON_BID_ITEM_PRICES_INTERFACE# is referenced by following:

APPS: PON_BID_ITEM_PRICES_INTERFACE