DBA Data[Home] [Help]

VIEW: APPS.POFV_MC_INBOUND_SHIPMENTS

Source

View Text - Preformatted

SELECT null SET_OF_BOOKS_ID, null NAME, RH.SHIPMENT_HEADER_ID , RH.SHIPMENT_NUM , RH.RECEIPT_NUM , RH.CONVERSION_DATE , RH.CONVERSION_RATE , RH.CONVERSION_RATE_TYPE , RT.USER_CONVERSION_TYPE , RT.DESCRIPTION FROM RCV_SHIPMENT_HEADERS RH, GL_DAILY_CONVERSION_TYPES RT WHERE RH.CONVERSION_RATE_TYPE = RT.CONVERSION_TYPE WITH READ ONLY
View Text - HTML Formatted

SELECT NULL SET_OF_BOOKS_ID
, NULL NAME
, RH.SHIPMENT_HEADER_ID
, RH.SHIPMENT_NUM
, RH.RECEIPT_NUM
, RH.CONVERSION_DATE
, RH.CONVERSION_RATE
, RH.CONVERSION_RATE_TYPE
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
FROM RCV_SHIPMENT_HEADERS RH
, GL_DAILY_CONVERSION_TYPES RT
WHERE RH.CONVERSION_RATE_TYPE = RT.CONVERSION_TYPE WITH READ ONLY