[Home] [Help]
SELECT EOD.ROWID, EOD.ORDER_ID, EOD.ELM_RNG_ORDER_NAME, EOD.ORDER_NUM, EOD.ORDER_ATTR_VALUE, UTL.DESCRIPTION, EOD.CREATED_BY, EOD.CREATION_DATE, EOD.LAST_UPDATE_DATE, EOD.LAST_UPDATED_BY, EOD.LAST_UPDATE_LOGIN FROM IGS_FI_ER_ORD_DTLS EOD, IGS_PS_UNIT_TYPE_LVL UTL WHERE EOD.ORDER_ATTR_VALUE = TO_CHAR (UTL.UNIT_TYPE_ID)
SELECT EOD.ROWID
, EOD.ORDER_ID
, EOD.ELM_RNG_ORDER_NAME
, EOD.ORDER_NUM
, EOD.ORDER_ATTR_VALUE
, UTL.DESCRIPTION
, EOD.CREATED_BY
, EOD.CREATION_DATE
, EOD.LAST_UPDATE_DATE
, EOD.LAST_UPDATED_BY
, EOD.LAST_UPDATE_LOGIN
FROM IGS_FI_ER_ORD_DTLS EOD
, IGS_PS_UNIT_TYPE_LVL UTL
WHERE EOD.ORDER_ATTR_VALUE = TO_CHAR (UTL.UNIT_TYPE_ID)
|
|
|
|