VIEW: APPS.BIS_LEGAL_ENTITIES_V

Source

View Text - Preformatted

SELECT TO_CHAR(L.ORGANIZATION_ID) , L.NAME , B.RESPONSIBILITY_ID FROM HR_LEGAL_ENTITIES L , BIS_BUSINESS_GROUPS_V B WHERE L.BUSINESS_GROUP_ID = B.ID

View Text - HTML Formatted

SELECT TO_CHAR(L.ORGANIZATION_ID)
, L.NAME
, B.RESPONSIBILITY_ID
FROM HR_LEGAL_ENTITIES L
, BIS_BUSINESS_GROUPS_V B
WHERE L.BUSINESS_GROUP_ID = B.ID