VIEW: APPS.PSP_CLEARING_ACCOUNT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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