SELECT ACC.ACCESS_ID , TTB.TRANSACTION_TYPE_ID , TTB.REVISION_FLAG , TTB.LINE_ORDER_CATEGORY_CODE , TTB.START_DATE_ACTIVE , TTB.END_DATE_ACTIVE , TTL.NAME , TTL.DESCRIPTION ,TTB.TRAVEL_FLAG FROM CS_TRANSACTION_TYPES_B TTB , CS_TRANSACTION_TYPES_TL TTL , CSM_TRANSACTION_TYPES_ACC ACC WHERE TTB.TRANSACTION_TYPE_ID = ACC.TRANSACTION_TYPE_ID AND TTB.TRANSACTION_TYPE_ID = TTL.TRANSACTION_TYPE_ID AND TTL.LANGUAGE = ASG_BASE.Get_Language
SELECT ACC.ACCESS_ID
, TTB.TRANSACTION_TYPE_ID
, TTB.REVISION_FLAG
, TTB.LINE_ORDER_CATEGORY_CODE
, TTB.START_DATE_ACTIVE
, TTB.END_DATE_ACTIVE
, TTL.NAME
, TTL.DESCRIPTION
, TTB.TRAVEL_FLAG
FROM CS_TRANSACTION_TYPES_B TTB
, CS_TRANSACTION_TYPES_TL TTL
, CSM_TRANSACTION_TYPES_ACC ACC
WHERE TTB.TRANSACTION_TYPE_ID = ACC.TRANSACTION_TYPE_ID
AND TTB.TRANSACTION_TYPE_ID = TTL.TRANSACTION_TYPE_ID
AND TTL.LANGUAGE = ASG_BASE.GET_LANGUAGE
|
|
|