[Home] [Help]
View: WSH_SHIP_FROM_ORGS_V
View Text
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
, MTL_PARAMETERS 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'
Columns
Name |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
USER_DEFINITION_ENABLE_DATE |
DISABLE_DATE |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
LOCATION_ID |
SET_OF_BOOKS_ID |