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

VIEW: PON.PON_BID_PAYMENTS_SHIPMENTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BID_PAYMENT_ID NUMBER
Yes
BID_NUMBER NUMBER
Yes
BID_LINE_NUMBER NUMBER
Yes
AUCTION_HEADER_ID NUMBER
Yes
AUCTION_LINE_NUMBER NUMBER
Yes
PAYMENT_DISPLAY_NUMBER NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PAYMENT_DESCRIPTION VARCHAR2 (240)
AUCTION_PAYMENT_ID NUMBER

PAYMENT_TYPE_CODE VARCHAR2 (30)
QUANTITY NUMBER

UOM_CODE VARCHAR2 (3)
PRICE NUMBER

BID_CURRENCY_PRICE NUMBER

PROMISED_DATE DATE

OLD_PAYMENT_DISPLAY_NUMBER NUMBER

OLD_PAYMENT_TYPE_CODE VARCHAR2 (30)
OLD_PAYMENT_DESCRIPTION VARCHAR2 (240)
OLD_QUANTITY NUMBER

OLD_UOM_CODE VARCHAR2 (3)
OLD_BID_CURRENCY_PRICE NUMBER

OLD_PROMISED_DATE DATE

Query Text

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


SELECT BID_PAYMENT_ID
,      BID_NUMBER
,      BID_LINE_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      PAYMENT_DISPLAY_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_DESCRIPTION
,      AUCTION_PAYMENT_ID
,      PAYMENT_TYPE_CODE
,      QUANTITY
,      UOM_CODE
,      PRICE
,      BID_CURRENCY_PRICE
,      PROMISED_DATE
,      OLD_PAYMENT_DISPLAY_NUMBER
,      OLD_PAYMENT_TYPE_CODE
,      OLD_PAYMENT_DESCRIPTION
,      OLD_QUANTITY
,      OLD_UOM_CODE
,      OLD_BID_CURRENCY_PRICE
,      OLD_PROMISED_DATE
FROM PON.PON_BID_PAYMENTS_SHIPMENTS#;

Dependencies

[top of page]

PON.PON_BID_PAYMENTS_SHIPMENTS# references the following:

SchemaPON
TablePON_BID_PAYMENTS_SHIPMENTS
PON.PON_BID_PAYMENTS_SHIPMENTS# is referenced by following:

SchemaAPPS
SynonymPON_BID_PAYMENTS_SHIPMENTS