View: ZX_SYNC_LINES_INPUT_V

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

View Text

SELECT /* REMOVED AS PER BUG 5090593 ZLDF.INTERNAL_ORGANIZATION_ID
, ZTPPO.LEGAL_ENTITY_NUMBER
, ZTPPO.ESTABLISHMENT_NAME
, */ ZLDF.EVENT_CLASS_MAPPING_ID
, ZLDF.TRX_ID
, ZLDF.TRX_LINE_ID
, ZLDF.TRX_LEVEL_TYPE
, ZLDF.TRX_LINE_NUMBER
, /*BUG 5090593 TRX_NUMBER CHANGED TO TRX_LINE_NUMBER */ ZLDF.TRX_DESCRIPTION
, ZLDF.PRODUCT_DESCRIPTION
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE1
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE2
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE3
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE4
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE5
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE6
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE7
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE8
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE9
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE10
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE11
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE12
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE13
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE14
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE15
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE16
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE17
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE18
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE19
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE20
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE21
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE22
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE23
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE24
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE25
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE26
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE27
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE28
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE29
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE30
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE1
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE2
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE3
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE4
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE5
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE6
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE7
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE8
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE9
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE10
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE1
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE2
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE3
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE4
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE5 FROM ZX_LINES_DET_FACTORS ZLDF
, ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
, ZX_PRVDR_LINE_EXTNS_GT ZPSLEA 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 ZLDF.EVENT_ID = NVL(ZTPPO.EVENT_ID
, ZLDF.EVENT_ID)
AND ZTPPO.RECORD_FOR_PARTNERS_FLAG = 'Y'
AND ZTPPO.RECORD_FLAG = 'Y'
AND ZTPPO.QUOTE_FLAG = 'N'
AND ZTPPO.TAX_EVENT_TYPE_CODE = 'UPDATE' /* LINE LEVEL EXTENSIBLE ATTRIBUTES */
AND ZPSLEA.APPLICATION_ID = ZTPPO.APPLICATION_ID
AND ZPSLEA.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZPSLEA.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZPSLEA.TRX_ID = ZTPPO.TRX_ID
AND ZPSLEA.PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZPSLEA.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE