[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: |
APPS.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 |