[Home] [Help] [Dependency Information]
Object Name: | PON_BID_ITEM_PRICES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | PON |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|