VIEW: ICX.ICX_POR_PRICE_LIST_LINES#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, SUPPLIER_ID SUPPLIER_ID, BUYER_ID BUYER_ID, ITEM_ID ITEM_ID, UNIT_PRICE UNIT_PRICE, UOM UOM, CURRENCY_CODE CURRENCY_CODE, BUYER_APPROVAL_STATUS BUYER_APPROVAL_STATUS, BUYER_APPROVAL_DATE BUYER_APPROVAL_DATE, INACTIVE_DATE INACTIVE_DATE, DESCRIPTION DESCRIPTION, RATE RATE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, BUYER_FUNCTIONAL_CURRENCY BUYER_FUNCTIONAL_CURRENCY, 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, SUPPLIER_SITE SUPPLIER_SITE, JOB_NUMBER JOB_NUMBER, ACTION ACTION, PUBLISHED_DATE PUBLISHED_DATE, OUTDATED_DATE OUTDATED_DATE, DELETED_DATE DELETED_DATE, REJECTED_DATE REJECTED_DATE, COMMENTS COMMENTS, PRICE_CODE PRICE_CODE, SUPPLIERCOMMENTS SUPPLIERCOMMENTS, PRICE_BREAK_ID PRICE_BREAK_ID, PRICE_BREAK_COUNT PRICE_BREAK_COUNT, EFFECTIVE_BEGINDATE EFFECTIVE_BEGINDATE, EFFECTIVE_ENDDATE EFFECTIVE_ENDDATE, BEGINDATE BEGINDATE, ENDDATE ENDDATE, CONTRACT_REFERENCE_NUM CONTRACT_REFERENCE_NUM, CONTRACT_REFERENCE_ID CONTRACT_REFERENCE_ID, PAYMENT_TERM PAYMENT_TERM, PRICE_FACTOR PRICE_FACTOR, DEFAULT_FLAG DEFAULT_FLAG, OTHER_COMBINATIONS_FLAG OTHER_COMBINATIONS_FLAG from "ICX"."ICX_POR_PRICE_LIST_LINES"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, SUPPLIER_ID SUPPLIER_ID
, BUYER_ID BUYER_ID
, ITEM_ID ITEM_ID
, UNIT_PRICE UNIT_PRICE
, UOM UOM
, CURRENCY_CODE CURRENCY_CODE
, BUYER_APPROVAL_STATUS BUYER_APPROVAL_STATUS
, BUYER_APPROVAL_DATE BUYER_APPROVAL_DATE
, INACTIVE_DATE INACTIVE_DATE
, DESCRIPTION DESCRIPTION
, RATE RATE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, BUYER_FUNCTIONAL_CURRENCY BUYER_FUNCTIONAL_CURRENCY
, 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
, SUPPLIER_SITE SUPPLIER_SITE
, JOB_NUMBER JOB_NUMBER
, ACTION ACTION
, PUBLISHED_DATE PUBLISHED_DATE
, OUTDATED_DATE OUTDATED_DATE
, DELETED_DATE DELETED_DATE
, REJECTED_DATE REJECTED_DATE
, COMMENTS COMMENTS
, PRICE_CODE PRICE_CODE
, SUPPLIERCOMMENTS SUPPLIERCOMMENTS
, PRICE_BREAK_ID PRICE_BREAK_ID
, PRICE_BREAK_COUNT PRICE_BREAK_COUNT
, EFFECTIVE_BEGINDATE EFFECTIVE_BEGINDATE
, EFFECTIVE_ENDDATE EFFECTIVE_ENDDATE
, BEGINDATE BEGINDATE
, ENDDATE ENDDATE
, CONTRACT_REFERENCE_NUM CONTRACT_REFERENCE_NUM
, CONTRACT_REFERENCE_ID CONTRACT_REFERENCE_ID
, PAYMENT_TERM PAYMENT_TERM
, PRICE_FACTOR PRICE_FACTOR
, DEFAULT_FLAG DEFAULT_FLAG
, OTHER_COMBINATIONS_FLAG OTHER_COMBINATIONS_FLAG
FROM "ICX"."ICX_POR_PRICE_LIST_LINES"