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.

VIEW: APPS.ZX_SYNC_LINES_INPUT_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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