Product: | OE - Order Entry |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.SO_FREIGHT_CHARGES_V |
SELECT FC.ROWID ROW_ID
, FC.FREIGHT_CHARGE_ID
, FC.CREATION_DATE
, FC.CREATED_BY
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_LOGIN
, FT.DESCRIPTION
, FC.FREIGHT_CHARGE_TYPE_ID
, FT.NAME FREIGHT_CHARGE_TYPE_NAME
, FT.FREIGHT_CHARGE_TYPE_CODE
, L.MEANING CHARGE_TYPE_MEANING
, FC.PICKING_HEADER_ID
, FC.AMOUNT
, FC.CURRENCY_CODE
, FC.CONVERSION_DATE
, FC.CONVERSION_RATE
, FC.CONVERSION_TYPE_CODE
, FC.INVOICE_STATUS
, FC.CONTEXT
, FC.ATTRIBUTE1
, FC.ATTRIBUTE2
, FC.ATTRIBUTE3
, FC.ATTRIBUTE4
, FC.ATTRIBUTE5
, FC.ATTRIBUTE6
, FC.ATTRIBUTE7
, FC.ATTRIBUTE8
, FC.ATTRIBUTE9
, FC.ATTRIBUTE10
, FC.ATTRIBUTE11
, FC.ATTRIBUTE12
, FC.ATTRIBUTE13
, FC.ATTRIBUTE14
, FC.ATTRIBUTE15
FROM SO_LOOKUPS L
, SO_FREIGHT_CHARGE_TYPES FT
, SO_FREIGHT_CHARGES FC
WHERE FT.FREIGHT_CHARGE_TYPE_ID = FC.FREIGHT_CHARGE_TYPE_ID
AND FT.FREIGHT_CHARGE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'FREIGHT_CHARGE_TYPE'