VIEW: APPS.WSH_CHARGES_V

Source

View Text - Preformatted

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 , FC.DELIVERY_ID , H.HEADER_ID , H.ORDER_NUMBER , FC.PICKING_LINE_DETAIL_ID , FC.CONTAINER_ID , PC.SEQUENCE_NUMBER CONTAINER , 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 , FC.AC_ATTRIBUTE1 , FC.AC_ATTRIBUTE2 , FC.AC_ATTRIBUTE3 , FC.AC_ATTRIBUTE4 , FC.AC_ATTRIBUTE5 , FC.AC_ATTRIBUTE6 , FC.AC_ATTRIBUTE7 , FC.AC_ATTRIBUTE8 , FC.AC_ATTRIBUTE9 , FC.AC_ATTRIBUTE10 , FC.AC_ATTRIBUTE11 , FC.AC_ATTRIBUTE12 , FC.AC_ATTRIBUTE13 , FC.AC_ATTRIBUTE14 , FC.AC_ATTRIBUTE15 , FC.AC_ATTRIBUTE_CATEGORY FROM SO_LOOKUPS L , SO_FREIGHT_CHARGE_TYPES FT , SO_FREIGHT_CHARGES FC , SO_PICKING_HEADERS_ALL PH , SO_HEADERS_ALL H , WSH_PACKED_CONTAINERS PC 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' AND PH.PICKING_HEADER_ID(+) = FC.PICKING_HEADER_ID AND H.HEADER_ID(+) = PH.ORDER_HEADER_ID AND PC.CONTAINER_ID(+) = FC.CONTAINER_ID

View Text - HTML Formatted

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
, FC.DELIVERY_ID
, H.HEADER_ID
, H.ORDER_NUMBER
, FC.PICKING_LINE_DETAIL_ID
, FC.CONTAINER_ID
, PC.SEQUENCE_NUMBER CONTAINER
, 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
, FC.AC_ATTRIBUTE1
, FC.AC_ATTRIBUTE2
, FC.AC_ATTRIBUTE3
, FC.AC_ATTRIBUTE4
, FC.AC_ATTRIBUTE5
, FC.AC_ATTRIBUTE6
, FC.AC_ATTRIBUTE7
, FC.AC_ATTRIBUTE8
, FC.AC_ATTRIBUTE9
, FC.AC_ATTRIBUTE10
, FC.AC_ATTRIBUTE11
, FC.AC_ATTRIBUTE12
, FC.AC_ATTRIBUTE13
, FC.AC_ATTRIBUTE14
, FC.AC_ATTRIBUTE15
, FC.AC_ATTRIBUTE_CATEGORY
FROM SO_LOOKUPS L
, SO_FREIGHT_CHARGE_TYPES FT
, SO_FREIGHT_CHARGES FC
, SO_PICKING_HEADERS_ALL PH
, SO_HEADERS_ALL H
, WSH_PACKED_CONTAINERS PC
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'
AND PH.PICKING_HEADER_ID(+) = FC.PICKING_HEADER_ID
AND H.HEADER_ID(+) = PH.ORDER_HEADER_ID
AND PC.CONTAINER_ID(+) = FC.CONTAINER_ID