VIEW: PON.PON_AUC_PAYMENTS_SHIPMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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