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: APPS.ZX_O2C_CALC_TXN_INPUT_V

Source

View Text - Preformatted


SELECT
  zldf.internal_organization_id,
  zldf.event_class_mapping_id,
  zldf.trx_id,
  ztppo.application_short_name,
  zldf.tax_event_type_code,
  zldf.trx_date,
  zldf.trx_currency_code,
/*Bug 5090593   ztppo.quote_flag, */
  ztppo.legal_entity_number,
  ztppo.establishment_number,
  zldf.trx_number,
  zldf.trx_description,
  zldf.doc_seq_value,
  zldf.trx_due_date,
/*Bug 5090593   zldf.record_type_code, */
  ztppo.allow_tax_calculation_flag,
  zldf.trx_line_id,
  zldf.trx_level_type,
  /*IF record_for_partner_flag ='N' THEN
      IF line_level_action = 'UPDATE' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'ALLOCATE_LINE_ONLY_ADJUSTMENT' then   -- Bug 5007293
        line_level_action ='CREATE'
      ELSIF line_level_action = 'LINE_INFO_TAX_ONLY'' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'DISCARD' then
        line_level_action ='CANCEL'
      ELSE
        line_level_action = existing one
      END IF
    ELSIF record_for_partner_flag = 'Y' THEN
      IF line_level_action ='CREATE_TAX_ONLY' THEN
         line_level_action ='QUOTE'
      ELSIF line_level_action = 'COPY_AND_CREATE' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'ALLOCATE_LINE_ONLY_ADJUSTMENT' then   -- Bug 5007293
        line_level_action ='CREATE'
      ELSIF line_level_action = 'LINE_INFO_TAX_ONLY'' then
        line_level_action ='CREATE'
      ELSIF line_level_action = 'DISCARD' then
        line_level_action ='CANCEL'
      ELSE
        IF PARTNER_PROCESSING_FLAG  ='F' then
          IF line_level_action ='UPDATE' Then
            line_level_action ='CREATE'
          ELSE
   line_level_action = existing one
          END IF
 ELSE
          IF inclusive_tax_override_flag = 'Y'
            line_level_action = 'UPDATE'
          ELSE
            line_level_action = existing one
          END IF --partner processing flag
        END IF --line level action = CREATE_TAX_ONLY
      END IF --record for partner flag
  */
  DECODE(ztppo.record_for_partners_flag,'N',
    DECODE(zldf.line_level_action,'UPDATE','QUOTE','CREATE','QUOTE','ALLOCATE_TAX_ONLY_ADJUSTMENT','QUOTE','ALLOCATE_LINE_ONLY_ADJUSTMENT','QUOTE','LINE_INFO_TAX_ONLY','QUOTE','DISCARD','CANCEL',zldf.line_level_action), 'Y',
          DECODE(zldf.line_level_action,'CREATE_TAX_ONLY', 'QUOTE', 'COPY_AND_CREATE','CREATE','ALLOCATE_TAX_ONLY_ADJUSTMENT','CREATE','ALLOCATE_LINE_ONLY_ADJUSTMENT','CREATE','LINE_INFO_TAX_ONLY','CREATE','DISCARD','CANCEL',
            DECODE(ztppo.partner_processing_flag,'F',
                  DECODE(zldf.line_level_action, 'UPDATE', 'CREATE', zldf.line_level_action),
                    DECODE(zldf.inclusive_tax_override_flag, 'Y','UPDATE', ZLDF.LINE_LEVEL_ACTION)))), /* line_level_action */
  zldf.line_class,
  zldf.trx_shipping_date,
  zldf.trx_receipt_date,
  zldf.trx_line_type,
  zldf.trx_line_date,
  zldf.provnl_tax_determination_date, /*Bug 5090593 */
  NVL(zldf.trx_business_category, ztppo.event_class_code),
  zldf.line_intended_use,
  DECODE (zldf.line_amt_includes_tax_flag, 'I','A', line_amt_includes_tax_flag),
  zldf.line_amt,
  DECODE(zldf.line_amt_includes_tax_flag, 'S', ZX_TPI_SERVICES_PKG.get_incl_tax_amt(zldf.application_id,
                                                                                    zldf.entity_code,
                                                                                    zldf.event_class_code,
                                                                                    zldf.trx_id,
                                                                                    zldf.trx_line_id,
                                                                                    zldf.trx_level_type,
                                                                                    ztppo.tax_provider_id),null) , /* other_incl_tax_amt */
  zldf.trx_line_quantity,
  zldf.unit_price,
  zldf.cash_discount,
  zldf.volume_discount,
  zldf.trading_discount,
  zldf.transportation_charge,
  zldf.insurance_charge,
  zldf.other_charge,
  zldf.product_id,
 zldf.uom_code,
  zldf.product_type,
  zldf.product_code,
  zldf.fob_point,
 ptnr.ship_to_party_number,
  ptnr.ship_to_party_name,
  ptnr.ship_from_party_number,
  ptnr.ship_from_party_name,
  zldf.ship_to_location_id, /* Bug 5090593 */
  ptnr.ship_to_geography_type1,
  ptnr.ship_to_geography_value1,
  ptnr.ship_to_geography_type2,
  ptnr.ship_to_geography_value2,
  ptnr.ship_to_geography_type3,
  ptnr.ship_to_geography_value3,
  ptnr.ship_to_geography_type4,
  ptnr.ship_to_geography_value4,
  ptnr.ship_to_geography_type5,
  ptnr.ship_to_geography_value5,
  ptnr.ship_to_geography_type6,
  ptnr.ship_to_geography_value6,
  ptnr.ship_to_geography_type7,
  ptnr.ship_to_geography_value7,
  ptnr.ship_to_geography_type8,
  ptnr.ship_to_geography_value8,
  ptnr.ship_to_geography_type9,
  ptnr.ship_to_geography_value9,
  ptnr.ship_to_geography_type10,
  ptnr.ship_to_geography_value10,
  zldf.ship_from_location_id, /* Bug 5090593 */
  ptnr.ship_from_geography_type1,
  ptnr.ship_from_geography_value1,
  ptnr.ship_from_geography_type2,
  ptnr.ship_from_geography_value2,
  ptnr.ship_from_geography_type3,
  ptnr.ship_from_geography_value3,
  ptnr.ship_from_geography_type4,
  ptnr.ship_from_geography_value4,
  ptnr.ship_from_geography_type5,
  ptnr.ship_from_geography_value5,
  ptnr.ship_from_geography_type6,
  ptnr.ship_from_geography_value6,
  ptnr.ship_from_geography_type7,
  ptnr.ship_from_geography_value7,
  ptnr.ship_from_geography_type8,
 ptnr.ship_from_geography_value8,
  ptnr.ship_from_geography_type9,
  ptnr.ship_from_geography_value9,
  ptnr.ship_from_geography_type10,
ptnr.ship_from_geography_value10,
  zldf.poa_location_id, /* Bug 5090593 */
  ptnr.poa_geography_type1,
  ptnr.poa_geography_value1,
  ptnr.poa_geography_type2,
  ptnr.poa_geography_value2,
  ptnr.poa_geography_type3,
  ptnr.poa_geography_value3,
  ptnr.poa_geography_type4,
  ptnr.poa_geography_value4,
  ptnr.poa_geography_type5,
  ptnr.poa_geography_value5,
  ptnr.poa_geography_type6,
  ptnr.poa_geography_value6,
  ptnr.poa_geography_type7,
  ptnr.poa_geography_value7,
  ptnr.poa_geography_type8,
  ptnr.poa_geography_value8,
  ptnr.poa_geography_type9,
  ptnr.poa_geography_value9,
  ptnr.poa_geography_type10,
  ptnr.poa_geography_value10,
  zldf.poo_location_id, /* Bug 5090593 */
  ptnr.poo_geography_type1,
  ptnr.poo_geography_value1,
  ptnr.poo_geography_type2,
  ptnr.poo_geography_value2,
  ptnr.poo_geography_type3,
  ptnr.poo_geography_value3,
  ptnr.poo_geography_type4,
  ptnr.poo_geography_value4,
  ptnr.poo_geography_type5,
  ptnr.poo_geography_value5,
  ptnr.poo_geography_type6,
  ptnr.poo_geography_value6,
  ptnr.poo_geography_type7,
  ptnr.poo_geography_value7,
  ptnr.poo_geography_type8,
  ptnr.poo_geography_value8,
  ptnr.poo_geography_type9,
  ptnr.poo_geography_value9,
 ptnr.poo_geography_type10,
  ptnr.poo_geography_value10,
  ptnr.bill_to_party_number,
  ptnr.bill_to_party_name,
 ptnr.bill_from_party_number,
  ptnr.bill_from_party_name,
  zldf.bill_to_location_id, /* Bug 5090593 */
  ptnr.bill_to_geography_type1,
  ptnr.bill_to_geography_value1,
  ptnr.bill_to_geography_type2,
  ptnr.bill_to_geography_value2,
  ptnr.bill_to_geography_type3,
  ptnr.bill_to_geography_value3,
  ptnr.bill_to_geography_type4,
  ptnr.bill_to_geography_value4,
  ptnr.bill_to_geography_type5,
  ptnr.bill_to_geography_value5,
  ptnr.bill_to_geography_type6,
  ptnr.bill_to_geography_value6,
  ptnr.bill_to_geography_type7,
  ptnr.bill_to_geography_value7,
  ptnr.bill_to_geography_type8,
  ptnr.bill_to_geography_value8,
  ptnr.bill_to_geography_type9,
  ptnr.bill_to_geography_value9,
  ptnr.bill_to_geography_type10,
  ptnr.bill_to_geography_value10,
  zldf.bill_from_location_id, /* Bug 5090593 */
  ptnr.bill_from_geography_type1,
  ptnr.bill_from_geography_value1,
  ptnr.bill_from_geography_type2,
  ptnr.bill_from_geography_value2,
  ptnr.bill_from_geography_type3,
  ptnr.bill_from_geography_value3,
  ptnr.bill_from_geography_type4,
  ptnr.bill_from_geography_value4,
  ptnr.bill_from_geography_type5,
  ptnr.bill_from_geography_value5,
  ptnr.bill_from_geography_type6,
  ptnr.bill_from_geography_value6,
  ptnr.bill_from_geography_type7,
  ptnr.bill_from_geography_value7,
  ptnr.bill_from_geography_type8,
  ptnr.bill_from_geography_value8,
  ptnr.bill_from_geography_type9,
 ptnr.bill_from_geography_value9,
  ptnr.bill_from_geography_type10,
  ptnr.bill_from_geography_value10,
  zldf.account_ccid,
 to_number(NULL), /* applied from document type id Bug 5090593: Applied to_number function */
  zldf.applied_from_trx_id,
  zldf.applied_from_line_id,
  zldf.applied_from_trx_level_type,
  zldf.applied_from_trx_number,
  decode(zldf.adjusted_doc_application_id, 222,
         decode(zldf.ADJUSTED_DOC_EVENT_CLASS_CODE, 'INVOICE', 4,
                                                    'DEBIT_MEMO', 5,
                                                    'CREDIT_MEMO', 6, NULL),
         NULL), /* adjusted doc document type id */
  zldf.adjusted_doc_trx_id,
  zldf.adjusted_doc_line_id,
  zldf.adjusted_doc_trx_level_type,
  zldf.adjusted_doc_number,
  zldf.adjusted_doc_date,
  zldf.assessable_value,
  zldf.trx_line_number,
  zldf.trx_line_description,
  zldf.product_description,
  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,
  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,
  zldf.EXEMPT_CERTIFICATE_NUMBER,
  zldf.EXEMPT_REASON ,
  zldf.EXEMPTION_CONTROL_FLAG
FROM
  ZX_LINES_DET_FACTORS zldf,
  ZX_PRVDR_HDR_EXTNS_GT zpshea,
  ZX_PRVDR_LINE_EXTNS_GT zpslea,
  ZX_TRX_PRE_PROC_OPTIONS_GT ztppo,
/*  ZX_EVNT_CLS_MAPPINGS appecm,
  ZX_EVNT_CLS_MAPPINGS adjecm,
*/
  ZX_PTNR_LOCATION_INFO_GT ptnr
WHERE /* Main Transaction Selection */
      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
   /* Address Elements Joins */
  AND zldf.event_class_mapping_id = ptnr.event_class_mapping_id
  AND zldf.trx_id = ptnr.trx_id
  AND zldf.trx_line_id = ptnr.trx_line_id
  AND zldf.trx_level_type = ptnr.trx_level_type
/* Party Elements Joins
  --AND stp.party_id = zldf.ship_to_party_id
  --AND sfp.party_id = zldf.ship_from_party_id
  --AND btp.party_id = zldf.bill_to_party_id
--AND bfp.party_id = zldf.bill_from_party_id
 */
/* 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.trx_line_id = zldf.trx_line_id
  AND zpslea.trx_level_type = zldf.trx_level_type
  AND zpslea.provider_id = ztppo.tax_provider_id
  AND zpslea.tax_regime_code = ztppo.tax_regime_code
  /*header level extensible attributes*/
  AND zpshea.application_id = ztppo.application_id
  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
  /*Other conditions for eliminating line*/
  AND ((ztppo.record_flag = 'Y' AND ztppo.quote_flag = 'N'
        AND
        ((ztppo.tax_event_type_code = 'UPDATE' AND
          ( (ztppo.record_for_partners_flag = 'Y'
             AND
             ( (ztppo.partner_processing_flag = 'F'
                AND zldf.trx_id = ztppo.trx_id AND zldf.line_level_action <> 'CREATE_TAX_ONLY')
                OR
               (ztppo.partner_processing_flag <> 'F'
                AND (zldf.event_id = ztppo.event_id
                    OR (zldf.trx_id = ztppo.trx_id AND  zldf.line_level_action = 'DELETE')
                    )
               )
             )
            )
            OR  (ztppo.record_for_partners_flag = 'N' AND zldf.trx_id = ZTPPO.TRX_ID)
          )
         )
        OR (ztppo.tax_event_type_code in ('CREATE', 'CREATE_REVERSE_DOCUMENT') and zldf.event_id = ZTPPO.EVENT_ID)
        OR (ztppo.tax_event_type_code = 'OVERRIDE_TAX' and (zldf.inclusive_tax_override_flag='Y'))
        )
       )
       OR (ztppo.record_flag = 'N' OR ztppo.quote_flag = 'Y' )
      )

View Text - HTML Formatted

SELECT ZLDF.INTERNAL_ORGANIZATION_ID
, ZLDF.EVENT_CLASS_MAPPING_ID
, ZLDF.TRX_ID
, ZTPPO.APPLICATION_SHORT_NAME
, ZLDF.TAX_EVENT_TYPE_CODE
, ZLDF.TRX_DATE
, ZLDF.TRX_CURRENCY_CODE
, /*BUG 5090593 ZTPPO.QUOTE_FLAG
, */ ZTPPO.LEGAL_ENTITY_NUMBER
, ZTPPO.ESTABLISHMENT_NUMBER
, ZLDF.TRX_NUMBER
, ZLDF.TRX_DESCRIPTION
, ZLDF.DOC_SEQ_VALUE
, ZLDF.TRX_DUE_DATE
, /*BUG 5090593 ZLDF.RECORD_TYPE_CODE
, */ ZTPPO.ALLOW_TAX_CALCULATION_FLAG
, ZLDF.TRX_LINE_ID
, ZLDF.TRX_LEVEL_TYPE
, /*IF RECORD_FOR_PARTNER_FLAG ='N' THEN IF LINE_LEVEL_ACTION = 'UPDATE' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'ALLOCATE_LINE_ONLY_ADJUSTMENT' THEN -- BUG 5007293 LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'LINE_INFO_TAX_ONLY'' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'DISCARD' THEN LINE_LEVEL_ACTION ='CANCEL' ELSE LINE_LEVEL_ACTION = EXISTING ONE END IF ELSIF RECORD_FOR_PARTNER_FLAG = 'Y' THEN IF LINE_LEVEL_ACTION ='CREATE_TAX_ONLY' THEN LINE_LEVEL_ACTION ='QUOTE' ELSIF LINE_LEVEL_ACTION = 'COPY_AND_CREATE' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'ALLOCATE_LINE_ONLY_ADJUSTMENT' THEN -- BUG 5007293 LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'LINE_INFO_TAX_ONLY'' THEN LINE_LEVEL_ACTION ='CREATE' ELSIF LINE_LEVEL_ACTION = 'DISCARD' THEN LINE_LEVEL_ACTION ='CANCEL' ELSE IF PARTNER_PROCESSING_FLAG ='F' THEN IF LINE_LEVEL_ACTION ='UPDATE' THEN LINE_LEVEL_ACTION ='CREATE' ELSE LINE_LEVEL_ACTION = EXISTING ONE END IF ELSE IF INCLUSIVE_TAX_OVERRIDE_FLAG = 'Y' LINE_LEVEL_ACTION = 'UPDATE' ELSE LINE_LEVEL_ACTION = EXISTING ONE END IF --PARTNER PROCESSING FLAG END IF --LINE LEVEL ACTION = CREATE_TAX_ONLY END IF --RECORD FOR PARTNER FLAG */ DECODE(ZTPPO.RECORD_FOR_PARTNERS_FLAG
, 'N'
, DECODE(ZLDF.LINE_LEVEL_ACTION
, 'UPDATE'
, 'QUOTE'
, 'CREATE'
, 'QUOTE'
, 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
, 'QUOTE'
, 'ALLOCATE_LINE_ONLY_ADJUSTMENT'
, 'QUOTE'
, 'LINE_INFO_TAX_ONLY'
, 'QUOTE'
, 'DISCARD'
, 'CANCEL'
, ZLDF.LINE_LEVEL_ACTION)
, 'Y'
, DECODE(ZLDF.LINE_LEVEL_ACTION
, 'CREATE_TAX_ONLY'
, 'QUOTE'
, 'COPY_AND_CREATE'
, 'CREATE'
, 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
, 'CREATE'
, 'ALLOCATE_LINE_ONLY_ADJUSTMENT'
, 'CREATE'
, 'LINE_INFO_TAX_ONLY'
, 'CREATE'
, 'DISCARD'
, 'CANCEL'
, DECODE(ZTPPO.PARTNER_PROCESSING_FLAG
, 'F'
, DECODE(ZLDF.LINE_LEVEL_ACTION
, 'UPDATE'
, 'CREATE'
, ZLDF.LINE_LEVEL_ACTION)
, DECODE(ZLDF.INCLUSIVE_TAX_OVERRIDE_FLAG
, 'Y'
, 'UPDATE'
, ZLDF.LINE_LEVEL_ACTION))))
, /* LINE_LEVEL_ACTION */ ZLDF.LINE_CLASS
, ZLDF.TRX_SHIPPING_DATE
, ZLDF.TRX_RECEIPT_DATE
, ZLDF.TRX_LINE_TYPE
, ZLDF.TRX_LINE_DATE
, ZLDF.PROVNL_TAX_DETERMINATION_DATE
, /*BUG 5090593 */ NVL(ZLDF.TRX_BUSINESS_CATEGORY
, ZTPPO.EVENT_CLASS_CODE)
, ZLDF.LINE_INTENDED_USE
, DECODE (ZLDF.LINE_AMT_INCLUDES_TAX_FLAG
, 'I'
, 'A'
, LINE_AMT_INCLUDES_TAX_FLAG)
, ZLDF.LINE_AMT
, DECODE(ZLDF.LINE_AMT_INCLUDES_TAX_FLAG
, 'S'
, ZX_TPI_SERVICES_PKG.GET_INCL_TAX_AMT(ZLDF.APPLICATION_ID
, ZLDF.ENTITY_CODE
, ZLDF.EVENT_CLASS_CODE
, ZLDF.TRX_ID
, ZLDF.TRX_LINE_ID
, ZLDF.TRX_LEVEL_TYPE
, ZTPPO.TAX_PROVIDER_ID)
, NULL)
, /* OTHER_INCL_TAX_AMT */ ZLDF.TRX_LINE_QUANTITY
, ZLDF.UNIT_PRICE
, ZLDF.CASH_DISCOUNT
, ZLDF.VOLUME_DISCOUNT
, ZLDF.TRADING_DISCOUNT
, ZLDF.TRANSPORTATION_CHARGE
, ZLDF.INSURANCE_CHARGE
, ZLDF.OTHER_CHARGE
, ZLDF.PRODUCT_ID
, ZLDF.UOM_CODE
, ZLDF.PRODUCT_TYPE
, ZLDF.PRODUCT_CODE
, ZLDF.FOB_POINT
, PTNR.SHIP_TO_PARTY_NUMBER
, PTNR.SHIP_TO_PARTY_NAME
, PTNR.SHIP_FROM_PARTY_NUMBER
, PTNR.SHIP_FROM_PARTY_NAME
, ZLDF.SHIP_TO_LOCATION_ID
, /* BUG 5090593 */ PTNR.SHIP_TO_GEOGRAPHY_TYPE1
, PTNR.SHIP_TO_GEOGRAPHY_VALUE1
, PTNR.SHIP_TO_GEOGRAPHY_TYPE2
, PTNR.SHIP_TO_GEOGRAPHY_VALUE2
, PTNR.SHIP_TO_GEOGRAPHY_TYPE3
, PTNR.SHIP_TO_GEOGRAPHY_VALUE3
, PTNR.SHIP_TO_GEOGRAPHY_TYPE4
, PTNR.SHIP_TO_GEOGRAPHY_VALUE4
, PTNR.SHIP_TO_GEOGRAPHY_TYPE5
, PTNR.SHIP_TO_GEOGRAPHY_VALUE5
, PTNR.SHIP_TO_GEOGRAPHY_TYPE6
, PTNR.SHIP_TO_GEOGRAPHY_VALUE6
, PTNR.SHIP_TO_GEOGRAPHY_TYPE7
, PTNR.SHIP_TO_GEOGRAPHY_VALUE7
, PTNR.SHIP_TO_GEOGRAPHY_TYPE8
, PTNR.SHIP_TO_GEOGRAPHY_VALUE8
, PTNR.SHIP_TO_GEOGRAPHY_TYPE9
, PTNR.SHIP_TO_GEOGRAPHY_VALUE9
, PTNR.SHIP_TO_GEOGRAPHY_TYPE10
, PTNR.SHIP_TO_GEOGRAPHY_VALUE10
, ZLDF.SHIP_FROM_LOCATION_ID
, /* BUG 5090593 */ PTNR.SHIP_FROM_GEOGRAPHY_TYPE1
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE1
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE2
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE2
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE3
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE3
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE4
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE4
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE5
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE5
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE6
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE6
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE7
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE7
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE8
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE8
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE9
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE9
, PTNR.SHIP_FROM_GEOGRAPHY_TYPE10
, PTNR.SHIP_FROM_GEOGRAPHY_VALUE10
, ZLDF.POA_LOCATION_ID
, /* BUG 5090593 */ PTNR.POA_GEOGRAPHY_TYPE1
, PTNR.POA_GEOGRAPHY_VALUE1
, PTNR.POA_GEOGRAPHY_TYPE2
, PTNR.POA_GEOGRAPHY_VALUE2
, PTNR.POA_GEOGRAPHY_TYPE3
, PTNR.POA_GEOGRAPHY_VALUE3
, PTNR.POA_GEOGRAPHY_TYPE4
, PTNR.POA_GEOGRAPHY_VALUE4
, PTNR.POA_GEOGRAPHY_TYPE5
, PTNR.POA_GEOGRAPHY_VALUE5
, PTNR.POA_GEOGRAPHY_TYPE6
, PTNR.POA_GEOGRAPHY_VALUE6
, PTNR.POA_GEOGRAPHY_TYPE7
, PTNR.POA_GEOGRAPHY_VALUE7
, PTNR.POA_GEOGRAPHY_TYPE8
, PTNR.POA_GEOGRAPHY_VALUE8
, PTNR.POA_GEOGRAPHY_TYPE9
, PTNR.POA_GEOGRAPHY_VALUE9
, PTNR.POA_GEOGRAPHY_TYPE10
, PTNR.POA_GEOGRAPHY_VALUE10
, ZLDF.POO_LOCATION_ID
, /* BUG 5090593 */ PTNR.POO_GEOGRAPHY_TYPE1
, PTNR.POO_GEOGRAPHY_VALUE1
, PTNR.POO_GEOGRAPHY_TYPE2
, PTNR.POO_GEOGRAPHY_VALUE2
, PTNR.POO_GEOGRAPHY_TYPE3
, PTNR.POO_GEOGRAPHY_VALUE3
, PTNR.POO_GEOGRAPHY_TYPE4
, PTNR.POO_GEOGRAPHY_VALUE4
, PTNR.POO_GEOGRAPHY_TYPE5
, PTNR.POO_GEOGRAPHY_VALUE5
, PTNR.POO_GEOGRAPHY_TYPE6
, PTNR.POO_GEOGRAPHY_VALUE6
, PTNR.POO_GEOGRAPHY_TYPE7
, PTNR.POO_GEOGRAPHY_VALUE7
, PTNR.POO_GEOGRAPHY_TYPE8
, PTNR.POO_GEOGRAPHY_VALUE8
, PTNR.POO_GEOGRAPHY_TYPE9
, PTNR.POO_GEOGRAPHY_VALUE9
, PTNR.POO_GEOGRAPHY_TYPE10
, PTNR.POO_GEOGRAPHY_VALUE10
, PTNR.BILL_TO_PARTY_NUMBER
, PTNR.BILL_TO_PARTY_NAME
, PTNR.BILL_FROM_PARTY_NUMBER
, PTNR.BILL_FROM_PARTY_NAME
, ZLDF.BILL_TO_LOCATION_ID
, /* BUG 5090593 */ PTNR.BILL_TO_GEOGRAPHY_TYPE1
, PTNR.BILL_TO_GEOGRAPHY_VALUE1
, PTNR.BILL_TO_GEOGRAPHY_TYPE2
, PTNR.BILL_TO_GEOGRAPHY_VALUE2
, PTNR.BILL_TO_GEOGRAPHY_TYPE3
, PTNR.BILL_TO_GEOGRAPHY_VALUE3
, PTNR.BILL_TO_GEOGRAPHY_TYPE4
, PTNR.BILL_TO_GEOGRAPHY_VALUE4
, PTNR.BILL_TO_GEOGRAPHY_TYPE5
, PTNR.BILL_TO_GEOGRAPHY_VALUE5
, PTNR.BILL_TO_GEOGRAPHY_TYPE6
, PTNR.BILL_TO_GEOGRAPHY_VALUE6
, PTNR.BILL_TO_GEOGRAPHY_TYPE7
, PTNR.BILL_TO_GEOGRAPHY_VALUE7
, PTNR.BILL_TO_GEOGRAPHY_TYPE8
, PTNR.BILL_TO_GEOGRAPHY_VALUE8
, PTNR.BILL_TO_GEOGRAPHY_TYPE9
, PTNR.BILL_TO_GEOGRAPHY_VALUE9
, PTNR.BILL_TO_GEOGRAPHY_TYPE10
, PTNR.BILL_TO_GEOGRAPHY_VALUE10
, ZLDF.BILL_FROM_LOCATION_ID
, /* BUG 5090593 */ PTNR.BILL_FROM_GEOGRAPHY_TYPE1
, PTNR.BILL_FROM_GEOGRAPHY_VALUE1
, PTNR.BILL_FROM_GEOGRAPHY_TYPE2
, PTNR.BILL_FROM_GEOGRAPHY_VALUE2
, PTNR.BILL_FROM_GEOGRAPHY_TYPE3
, PTNR.BILL_FROM_GEOGRAPHY_VALUE3
, PTNR.BILL_FROM_GEOGRAPHY_TYPE4
, PTNR.BILL_FROM_GEOGRAPHY_VALUE4
, PTNR.BILL_FROM_GEOGRAPHY_TYPE5
, PTNR.BILL_FROM_GEOGRAPHY_VALUE5
, PTNR.BILL_FROM_GEOGRAPHY_TYPE6
, PTNR.BILL_FROM_GEOGRAPHY_VALUE6
, PTNR.BILL_FROM_GEOGRAPHY_TYPE7
, PTNR.BILL_FROM_GEOGRAPHY_VALUE7
, PTNR.BILL_FROM_GEOGRAPHY_TYPE8
, PTNR.BILL_FROM_GEOGRAPHY_VALUE8
, PTNR.BILL_FROM_GEOGRAPHY_TYPE9
, PTNR.BILL_FROM_GEOGRAPHY_VALUE9
, PTNR.BILL_FROM_GEOGRAPHY_TYPE10
, PTNR.BILL_FROM_GEOGRAPHY_VALUE10
, ZLDF.ACCOUNT_CCID
, TO_NUMBER(NULL)
, /* APPLIED
FROM DOCUMENT TYPE ID BUG 5090593: APPLIED TO_NUMBER FUNCTION */ ZLDF.APPLIED_FROM_TRX_ID
, ZLDF.APPLIED_FROM_LINE_ID
, ZLDF.APPLIED_FROM_TRX_LEVEL_TYPE
, ZLDF.APPLIED_FROM_TRX_NUMBER
, DECODE(ZLDF.ADJUSTED_DOC_APPLICATION_ID
, 222
, DECODE(ZLDF.ADJUSTED_DOC_EVENT_CLASS_CODE
, 'INVOICE'
, 4
, 'DEBIT_MEMO'
, 5
, 'CREDIT_MEMO'
, 6
, NULL)
, NULL)
, /* ADJUSTED DOC DOCUMENT TYPE ID */ ZLDF.ADJUSTED_DOC_TRX_ID
, ZLDF.ADJUSTED_DOC_LINE_ID
, ZLDF.ADJUSTED_DOC_TRX_LEVEL_TYPE
, ZLDF.ADJUSTED_DOC_NUMBER
, ZLDF.ADJUSTED_DOC_DATE
, ZLDF.ASSESSABLE_VALUE
, ZLDF.TRX_LINE_NUMBER
, ZLDF.TRX_LINE_DESCRIPTION
, ZLDF.PRODUCT_DESCRIPTION
, 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
, 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
, ZLDF.EXEMPT_CERTIFICATE_NUMBER
, ZLDF.EXEMPT_REASON
, ZLDF.EXEMPTION_CONTROL_FLAG FROM ZX_LINES_DET_FACTORS ZLDF
, ZX_PRVDR_HDR_EXTNS_GT ZPSHEA
, ZX_PRVDR_LINE_EXTNS_GT ZPSLEA
, ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
, /* ZX_EVNT_CLS_MAPPINGS APPECM
, ZX_EVNT_CLS_MAPPINGS ADJECM
, */ ZX_PTNR_LOCATION_INFO_GT PTNR WHERE /* MAIN TRANSACTION SELECTION */ 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 /* ADDRESS ELEMENTS JOINS */
AND ZLDF.EVENT_CLASS_MAPPING_ID = PTNR.EVENT_CLASS_MAPPING_ID
AND ZLDF.TRX_ID = PTNR.TRX_ID
AND ZLDF.TRX_LINE_ID = PTNR.TRX_LINE_ID
AND ZLDF.TRX_LEVEL_TYPE = PTNR.TRX_LEVEL_TYPE /* PARTY ELEMENTS JOINS --AND STP.PARTY_ID = ZLDF.SHIP_TO_PARTY_ID --AND SFP.PARTY_ID = ZLDF.SHIP_FROM_PARTY_ID --AND BTP.PARTY_ID = ZLDF.BILL_TO_PARTY_ID --AND BFP.PARTY_ID = ZLDF.BILL_FROM_PARTY_ID */ /* 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.TRX_LINE_ID = ZLDF.TRX_LINE_ID
AND ZPSLEA.TRX_LEVEL_TYPE = ZLDF.TRX_LEVEL_TYPE
AND ZPSLEA.PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZPSLEA.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE /*HEADER LEVEL EXTENSIBLE ATTRIBUTES*/
AND ZPSHEA.APPLICATION_ID = ZTPPO.APPLICATION_ID
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 /*OTHER CONDITIONS FOR ELIMINATING LINE*/
AND ((ZTPPO.RECORD_FLAG = 'Y'
AND ZTPPO.QUOTE_FLAG = 'N' AND ((ZTPPO.TAX_EVENT_TYPE_CODE = 'UPDATE' AND ( (ZTPPO.RECORD_FOR_PARTNERS_FLAG = 'Y' AND ( (ZTPPO.PARTNER_PROCESSING_FLAG = 'F'
AND ZLDF.TRX_ID = ZTPPO.TRX_ID
AND ZLDF.LINE_LEVEL_ACTION <> 'CREATE_TAX_ONLY') OR (ZTPPO.PARTNER_PROCESSING_FLAG <> 'F'
AND (ZLDF.EVENT_ID = ZTPPO.EVENT_ID OR (ZLDF.TRX_ID = ZTPPO.TRX_ID
AND ZLDF.LINE_LEVEL_ACTION = 'DELETE') ) ) ) ) OR (ZTPPO.RECORD_FOR_PARTNERS_FLAG = 'N'
AND ZLDF.TRX_ID = ZTPPO.TRX_ID) ) ) OR (ZTPPO.TAX_EVENT_TYPE_CODE IN ('CREATE'
, 'CREATE_REVERSE_DOCUMENT')
AND ZLDF.EVENT_ID = ZTPPO.EVENT_ID) OR (ZTPPO.TAX_EVENT_TYPE_CODE = 'OVERRIDE_TAX'
AND (ZLDF.INCLUSIVE_TAX_OVERRIDE_FLAG='Y')) ) ) OR (ZTPPO.RECORD_FLAG = 'N' OR ZTPPO.QUOTE_FLAG = 'Y' ) )