eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ZX_SYNC_HDR_INPUT_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_SYNC_HDR_INPUT_V

View Text

SELECT ZLDF.INTERNAL_ORGANIZATION_ID
, ZTPPO.LEGAL_ENTITY_NUMBER
, ZTPPO.ESTABLISHMENT_NUMBER
, ZLDF.EVENT_CLASS_MAPPING_ID
, ZLDF.TRX_ID
, ZTPPO.APPLICATION_SHORT_NAME
, ZLDF.TAX_EVENT_TYPE_CODE
, ZLDF.TRX_NUMBER
, ZLDF.TRX_DESCRIPTION
, ZLDF.DOC_SEQ_VALUE
, ZLDF.TRX_DUE_DATE
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE5
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE6
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE7
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE8
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE9
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE10
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE11
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE12
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE13
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE14
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE15
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE16
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE17
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE18
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE19
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE20
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE21
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE22
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE23
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE24
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE25
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE26
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE27
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE28
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE29
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE30
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE5
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE6
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE7
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE8
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE9
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE10
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE5 FROM ZX_LINES_DET_FACTORS ZLDF
, ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
, ZX_PRVDR_HDR_EXTNS_GT ZPSHEA WHERE ZLDF.APPLICATION_ID = ZTPPO.APPLICATION_ID
AND ZLDF.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZLDF.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZLDF.TRX_ID = ZTPPO.TRX_ID
AND ZPSHEA.APPLICATION_ID = ZTPPO.APPLICATION_ID /*HEADER LEVEL EXTENSIBLE ATTRIBUTES */
AND ZPSHEA.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZPSHEA.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZPSHEA.TRX_ID = ZTPPO.TRX_ID
AND ZPSHEA.PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZPSHEA.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE
AND ROWNUM=1