DBA Data[Home] [Help]

VIEW: ICX.ICX_CAT_UPLOAD_PRICE_DUMP#

Source

View Text - Preformatted

select LINE_NUMBER LINE_NUMBER, ROW_TYPE ROW_TYPE, PROCESSED_FLAG PROCESSED_FLAG, LANGUAGE LANGUAGE, ACTION ACTION, SYSTEM_ACTION SYSTEM_ACTION, ERROR_FLAG ERROR_FLAG, ERROR_MESSAGE ERROR_MESSAGE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER SUPPLIER, SUPPLIER_PART_NUM SUPPLIER_PART_NUM, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID, UNIT_PRICE UNIT_PRICE, CURRENCY CURRENCY, UNIT_OF_MEASURE UNIT_OF_MEASURE, PRICE_LIST_NAME PRICE_LIST_NAME, PRICE_LIST_ID PRICE_LIST_ID, BUYER_NAME BUYER_NAME, ORG_ID ORG_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, CONTRACT_NUM CONTRACT_NUM, CONTRACT_ID CONTRACT_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "ICX"."ICX_CAT_UPLOAD_PRICE_DUMP"
View Text - HTML Formatted

SELECT LINE_NUMBER LINE_NUMBER
, ROW_TYPE ROW_TYPE
, PROCESSED_FLAG PROCESSED_FLAG
, LANGUAGE LANGUAGE
, ACTION ACTION
, SYSTEM_ACTION SYSTEM_ACTION
, ERROR_FLAG ERROR_FLAG
, ERROR_MESSAGE ERROR_MESSAGE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER SUPPLIER
, SUPPLIER_PART_NUM SUPPLIER_PART_NUM
, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID
, UNIT_PRICE UNIT_PRICE
, CURRENCY CURRENCY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, PRICE_LIST_NAME PRICE_LIST_NAME
, PRICE_LIST_ID PRICE_LIST_ID
, BUYER_NAME BUYER_NAME
, ORG_ID ORG_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, CONTRACT_NUM CONTRACT_NUM
, CONTRACT_ID CONTRACT_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "ICX"."ICX_CAT_UPLOAD_PRICE_DUMP"