WSH_SHIP_FROM_ORGS

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

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'

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'