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
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
|
|
|