MSC_PAYMENT_TERMS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
START_DATE_ACTIVE END_DATE_ACTIVE REFRESH_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE TERM_ID NAME DESCRIPTION SET_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT MSC_PAYMENT_TERMS_B.START_DATE_ACTIVE START_DATE_ACTIVE, MSC_PAYMENT_TERMS_B.END_DATE_ACTIVE END_DATE_ACTIVE, MSC_PAYMENT_TERMS_B.REFRESH_NUMBER REFRESH_NUMBER, MSC_PAYMENT_TERMS_B.CREATED_BY CREATED_BY, MSC_PAYMENT_TERMS_B.CREATION_DATE CREATION_DATE, MSC_PAYMENT_TERMS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_PAYMENT_TERMS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_PAYMENT_TERMS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_PAYMENT_TERMS_B.TERM_ID TERM_ID, MSC_PAYMENT_TERMS_TL.NAME NAME, MSC_PAYMENT_TERMS_TL.DESCRIPTION DESCRIPTION , 0 SET_ID FROM MSC_PAYMENT_TERMS_B, MSC_PAYMENT_TERMS_TL WHERE MSC_PAYMENT_TERMS_TL.TERM_ID = MSC_PAYMENT_TERMS_B.TERM_ID AND MSC_PAYMENT_TERMS_TL.LANGUAGE = USERENV('LANG') |