FND Design Data [Home] [Help]

View: PSP_ACCOUNTS_ORGANIZATIONS_V

Product: PSP - Labor Distribution
Description: Shows unique organizations that have default or suspense accounts defined for them
Implementation/DBA Data: ViewAPPS.PSP_ACCOUNTS_ORGANIZATIONS_V
View Text

SELECT DISTINCT(ORGANIZATION_ID)
, ORGANIZATION_NAME
, ACCOUNT_TYPE_CODE
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_ORGANIZATION_ACCOUNTS_V

Columns

Name
ORGANIZATION_ID
ORGANIZATION_NAME
ACCOUNT_TYPE_CODE
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID