VIEW: PON.PON_AUC_ITEMS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_AUCTION_HEADER_ID INTERFACE_AUCTION_HEADER_ID, INTERFACE_LINE_NUMBER INTERFACE_LINE_NUMBER, LINE_TYPE_ID LINE_TYPE_ID, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, ITEM_DESCRIPTION ITEM_DESCRIPTION, ORG_ID ORG_ID, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, QUANTITY QUANTITY, BID_START_PRICE BID_START_PRICE, NOTE_TO_BIDDERS NOTE_TO_BIDDERS, UOM_CODE UOM_CODE, ORIGINATION_CODE ORIGINATION_CODE, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, PRICE_BREAK_TYPE PRICE_BREAK_TYPE, ITEM_ID ITEM_ID, ITEM_NUMBER ITEM_NUMBER, ITEM_REVISION ITEM_REVISION, SOURCE_DOC_NUMBER SOURCE_DOC_NUMBER, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER, SOURCE_DOC_ID SOURCE_DOC_ID, SOURCE_LINE_ID SOURCE_LINE_ID, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, JOB_ID JOB_ID, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, PURCHASE_BASIS PURCHASE_BASIS, IP_CATEGORY_ID IP_CATEGORY_ID, CURRENT_PRICE CURRENT_PRICE, CLM_INFO_FLAG CLM_INFO_FLAG, LINE_NUM_DISPLAY LINE_NUM_DISPLAY, GROUP_LINE_ID GROUP_LINE_ID, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR, CLM_OPTION_NUM CLM_OPTION_NUM, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE, CLM_FUNDED_FLAG CLM_FUNDED_FLAG, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT, CLM_IDC_TYPE CLM_IDC_TYPE from "PON"."PON_AUC_ITEMS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_AUCTION_HEADER_ID INTERFACE_AUCTION_HEADER_ID
, INTERFACE_LINE_NUMBER INTERFACE_LINE_NUMBER
, LINE_TYPE_ID LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ORG_ID ORG_ID
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, QUANTITY QUANTITY
, BID_START_PRICE BID_START_PRICE
, NOTE_TO_BIDDERS NOTE_TO_BIDDERS
, UOM_CODE UOM_CODE
, ORIGINATION_CODE ORIGINATION_CODE
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, PRICE_BREAK_TYPE PRICE_BREAK_TYPE
, ITEM_ID ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, ITEM_REVISION ITEM_REVISION
, SOURCE_DOC_NUMBER SOURCE_DOC_NUMBER
, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER
, SOURCE_DOC_ID SOURCE_DOC_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JOB_ID JOB_ID
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, PURCHASE_BASIS PURCHASE_BASIS
, IP_CATEGORY_ID IP_CATEGORY_ID
, CURRENT_PRICE CURRENT_PRICE
, CLM_INFO_FLAG CLM_INFO_FLAG
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
, GROUP_LINE_ID GROUP_LINE_ID
, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR
, CLM_OPTION_NUM CLM_OPTION_NUM
, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG CLM_FUNDED_FLAG
, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM
, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE
, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT
, CLM_IDC_TYPE CLM_IDC_TYPE
FROM "PON"."PON_AUC_ITEMS_INTERFACE"