WSH_SHIP_FROM_ORGS_V
Details
-
Schema: FUSION
-
Object owner: WSH
-
Object type: VIEW
Columns
Name |
---|
ORGANIZATION_ID BUSINESS_GROUP_ID USER_DEFINITION_ENABLE_DATE DISABLE_DATE ORGANIZATION_CODE ORGANIZATION_NAME LOCATION_ID SET_OF_BOOKS_ID |
Query
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' |