[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PAA.ACCT_ID
, PAA. ACCT_SEQ_NUM
, PAA.ACCT_TYPE
, PAA.PERIOD_TYPE
, PAA.EXPENDITURE_TYPE
, PAA.SEGMENT_NUM
, PAA.NATURAL_ACCOUNT
, PAA.START_DATE_ACTIVE
, PAA.END_DATE_ACTIVE
, PAA. BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PAA.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, PAB.EXPENDITURE_TYPE BYPASS_EXPENDITURE_TYPE
, PAA.LAST_UPDATE_DATE
, PAA. LAST_UPDATED_BY
, PAA.CREATED_BY
, PAA.CREATION_DATE
FROM PSP_AUTO_ACCTS PAA
, PSP_AUTO_BYPASS PAB
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE PAA.EXPENDITURE_TYPE=PAB.EXPENDITURE_TYPE(+)
AND PAA.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PAA.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID WITH READ ONLY