[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POA.ORGANIZATION_ACCOUNT_ID
, POA.START_DATE_ACTIVE
, POA.END_DATE_ACTIVE
, '_LA:ACCOUNT_TYPE_CODE:PSP_LOOKUPS:PSP_ACCOUNT_TYPE_CODE:MEANING'
, POA.SET_OF_BOOKS_ID
, GSB.NAME SET_OF_BOOKS_NAME
, POA.BUSINESS_GROUP_ID
, HOU2.NAME BUSINESS_GROUP_NAME
, POA.COMMENTS
, POA.ORGANIZATION_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, POA.PROJECT_ID
, PPA.NAME
, POA.TASK_ID
, PT.TASK_NAME
, POA.AWARD_ID
, GAA.AWARD_FULL_NAME
, POA.EXPENDITURE_ORGANIZATION_ID
, POA.EXPENDITURE_TYPE
, POA.LAST_UPDATE_DATE
, POA.LAST_UPDATED_BY
, POA.CREATED_BY
, POA.CREATION_DATE
, HOU.NAME
FROM PSP_ORGANIZATION_ACCOUNTS POA
, GL_CODE_COMBINATIONS GCC
, HR_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GSB
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE POA.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND POA.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID(+)
AND POA.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
AND POA.PROJECT_ID = PPA.PROJECT_ID(+)
AND POA.TASK_ID = PT.TASK_ID(+)
AND POA.AWARD_ID = GAA.AWARD_ID(+)
AND POA.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND '_SEC:POA.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY