View: PSP_DISTRIBUTION_BATCH_NAME_V

Product:	PSP - Labor Distribution
Description:	View based on PSP_DISTRIBUTION_INTERFACE table
Implementation/DBA Data:	APPS.PSP_DISTRIBUTION_BATCH_NAME_V

View Text

SELECT DISTINCT BATCH_NAME
, NVL(CURRENCY_CODE
, PSP_GENERAL.GET_CURRENCY_CODE(BUSINESS_GROUP_ID)) CURRENCY_CODE
, GL_POSTING_OVERRIDE_DATE
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_DISTRIBUTION_INTERFACE
WHERE STATUS_CODE != 'T'

Columns