VIEW: PO.PO_RCV_CHARGES#

Source

View Text - Preformatted

select CHARGE_ID CHARGE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, INTERFACE_CHARGE_ID INTERFACE_CHARGE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, COST_FACTOR_ID COST_FACTOR_ID, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ALLOCATION_METHOD ALLOCATION_METHOD, UNIT_OF_MEASURE UNIT_OF_MEASURE, ESTIMATED_AMOUNT ESTIMATED_AMOUNT, ACTUAL_AMOUNT ACTUAL_AMOUNT, INCLUDE_IN_ACQUISITION_COST INCLUDE_IN_ACQUISITION_COST, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ESTIMATED_TAX ESTIMATED_TAX, ACTUAL_TAX ACTUAL_TAX, COST_COMPONENT_CLASS_ID COST_COMPONENT_CLASS_ID, COST_ANALYSIS_CODE COST_ANALYSIS_CODE from "PO"."PO_RCV_CHARGES"

View Text - HTML Formatted

SELECT CHARGE_ID CHARGE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, INTERFACE_CHARGE_ID INTERFACE_CHARGE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, COST_FACTOR_ID COST_FACTOR_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ALLOCATION_METHOD ALLOCATION_METHOD
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, INCLUDE_IN_ACQUISITION_COST INCLUDE_IN_ACQUISITION_COST
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ESTIMATED_TAX ESTIMATED_TAX
, ACTUAL_TAX ACTUAL_TAX
, COST_COMPONENT_CLASS_ID COST_COMPONENT_CLASS_ID
, COST_ANALYSIS_CODE COST_ANALYSIS_CODE
FROM "PO"."PO_RCV_CHARGES"