View: PA_EXPEND_OUTPUT_TAX

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_EXPEND_OUTPUT_TAX

View Text

SELECT EI.EXPENDITURE_ITEM_ID
, EOU.OUTPUT_TAX_CLASSIFICATION_CODE
, LK.MEANING
, EI.ORG_ID
FROM PA_EXPENDITURE_ITEMS EI
, PA_EXPENDITURE_TYPE_OUS_ALL EOU
, ZX_OUTPUT_CLASSIFICATIONS_V LK
WHERE EI.EXPENDITURE_TYPE = EOU.EXPENDITURE_TYPE
AND EOU.OUTPUT_TAX_CLASSIFICATION_CODE = LK.LOOKUP_CODE
AND LK.ORG_ID IN (EOU.ORG_ID
, -99)
AND LK.ENABLED_FLAG = 'Y'

Columns