View: PSP_CLEARING_ACCOUNT_V

Product:	PSP - Labor Distribution
Description:	Shows clearing accounts information
Implementation/DBA Data:	APPS.PSP_CLEARING_ACCOUNT_V

View Text

SELECT DISTINCT PCA.ROWID ROW_ID
, PCA.BUSINESS_GROUP_ID
, PCA.SET_OF_BOOKS_ID
, PCA.REVERSING_GL_CCID
, PCA.COMMENTS
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.LAST_UPDATE_LOGIN
, PCA.CREATED_BY
, PCA.CREATION_DATE
, PCA.PAYROLL_ID
, PPF.PAYROLL_NAME
FROM PSP_CLEARING_ACCOUNT PCA
, PAY_PAYROLLS_F PPF
WHERE PCA.PAYROLL_ID = PPF.PAYROLL_ID ORDER BY PPF.PAYROLL_NAME

Columns