DBA Data[Home] [Help] [Dependency Information]

VIEW: PON.PON_BID_SHIPMENTS_INT#

Object Details
Object Name: PON_BID_SHIPMENTS_INT#
Object Type: VIEW
Owner: PON
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes
INTERFACE_LINE_ID NUMBER

AUCTION_HEADER_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
BID_NUMBER NUMBER
Yes
AUCTION_SHIPMENT_NUMBER NUMBER

BID_SHIPMENT_NUMBER NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

QUANTITY NUMBER

PRICE_TYPE VARCHAR2 (25)
PRICE_DISCOUNT NUMBER

BID_CURRENCY_UNIT_PRICE NUMBER

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

ACTION NUMBER

WORKSHEET_NAME VARCHAR2 (80)
WORKSHEET_SEQUENCE_NUMBER NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

MAX_QUANTITY NUMBER

Query Text

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


SELECT BATCH_ID
,      INTERFACE_LINE_ID
,      AUCTION_HEADER_ID
,      LINE_NUMBER
,      BID_NUMBER
,      AUCTION_SHIPMENT_NUMBER
,      BID_SHIPMENT_NUMBER
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      QUANTITY
,      PRICE_TYPE
,      PRICE_DISCOUNT
,      BID_CURRENCY_UNIT_PRICE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ACTION
,      WORKSHEET_NAME
,      WORKSHEET_SEQUENCE_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MAX_QUANTITY
FROM PON.PON_BID_SHIPMENTS_INT#;

Dependencies

[top of page]

PON.PON_BID_SHIPMENTS_INT# references the following:

SchemaPON
TablePON_BID_SHIPMENTS_INT
PON.PON_BID_SHIPMENTS_INT# is referenced by following:

SchemaAPPS
SynonymPON_BID_SHIPMENTS_INT