[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 |