WSH_SHIP_FROM_ORGS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WSH
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ORGANIZATION_ID BUSINESS_GROUP_ID USER_DEFINITION_ENABLE_DATE DISABLE_DATE ORGANIZATION_CODE ORGANIZATION_NAME LOCATION_ID SET_OF_BOOKS_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID, HOU.BUSINESS_GROUP_ID, HOU.DATE_FROM USER_DEFINITION_ENABLE_DATE, HOU.DATE_TO DISABLE_DATE, MP.ORGANIZATION_CODE ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, HOU.location_id, HOI2.org_information1 set_of_books_id FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, HR_ORGANIZATION_INFORMATION HOI2, INV_ORG_PARAMETERS_V MP WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'INV' AND HOI1.ORG_INFORMATION2 = 'Y' AND HOI1.ORG_INFORMATION_CONTEXT = 'CLASS' and HOI2.ORG_INFORMATION_CONTEXT = 'Accounting Information' |