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

VIEW: PON.PON_AUC_PAYMENTS_SHIPMENTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_ID NUMBER
Yes
AUCTION_HEADER_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PAYMENT_DISPLAY_NUMBER NUMBER

PAYMENT_DESCRIPTION VARCHAR2 (240)
PAYMENT_TYPE_CODE VARCHAR2 (30)
SHIP_TO_LOCATION_ID NUMBER

QUANTITY NUMBER

UOM_CODE VARCHAR2 (3)
TARGET_PRICE NUMBER

NEED_BY_DATE DATE

WORK_APPROVER_USER_ID NUMBER

NOTE_TO_BIDDERS VARCHAR2 (4000)
PROJECT_ID NUMBER

PROJECT_TASK_ID NUMBER

PROJECT_AWARD_ID NUMBER

PROJECT_EXPENDITURE_TYPE VARCHAR2 (30)
PROJECT_EXP_ORGANIZATION_ID NUMBER

PROJECT_EXPENDITURE_ITEM_DATE DATE

Query Text

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


SELECT PAYMENT_ID
,      AUCTION_HEADER_ID
,      LINE_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_DISPLAY_NUMBER
,      PAYMENT_DESCRIPTION
,      PAYMENT_TYPE_CODE
,      SHIP_TO_LOCATION_ID
,      QUANTITY
,      UOM_CODE
,      TARGET_PRICE
,      NEED_BY_DATE
,      WORK_APPROVER_USER_ID
,      NOTE_TO_BIDDERS
,      PROJECT_ID
,      PROJECT_TASK_ID
,      PROJECT_AWARD_ID
,      PROJECT_EXPENDITURE_TYPE
,      PROJECT_EXP_ORGANIZATION_ID
,      PROJECT_EXPENDITURE_ITEM_DATE
FROM PON.PON_AUC_PAYMENTS_SHIPMENTS#;

Dependencies

[top of page]

PON.PON_AUC_PAYMENTS_SHIPMENTS# references the following:

SchemaPON
TablePON_AUC_PAYMENTS_SHIPMENTS
PON.PON_AUC_PAYMENTS_SHIPMENTS# is referenced by following:

SchemaAPPS
SynonymPON_AUC_PAYMENTS_SHIPMENTS