Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_GENERATE_COST_DIST_LINES displays information about cost distribution lines generated in Labor Distribution. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.DEFAULT_REASON_CODE
, PDL.GL_PROJECT_FLAG
, PDL.PRE_DISTRIBUTION_RUN_FLAG
, PDL.USER_DEFINED_FIELD
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:PDL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_ORG_ACCOUNT_ID
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.SUMMARY_LINE_ID
, PDL.SCHEDULE_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_ID
, PDL.ELEMENT_ACCOUNT_ID
, PDL.PAYROLL_SUB_LINE_ID
, PDL.DEFAULT_ORG_ACCOUNT_ID
, PDL.BUSINESS_GROUP_ID
, PDL.SET_OF_BOOKS_ID
FROM PSP_DISTRIBUTION_LINES PDL WITH READ ONLY