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_O2C_CALC_TXN_INPUT_V

Source

View Text - Preformatted


SELECT --bug#7247830
  internal_organization_id,
  document_type_id,
  transaction_id,
  application_code,
  document_level_action,
  trx_date,
  trx_currency_code,
  legal_entity_number,
  establishment_number,
  transaction_number,
  transaction_description,
  document_sequence_value,
  transaction_due_date,
  allow_tax_calculation,
  transaction_line_id,
  trx_level_type,
  line_level_action,
  line_class,
  transaction_shipping_date,
  transaction_receipt_date,
  transaction_line_type,
  transaction_line_date,
  provnl_tax_determination_date,
  trx_business_category,
  line_intended_use,
  line_amt_includes_tax_flag,
  line_amount,
  other_inclusive_tax_amount,
  transaction_line_quantity,
  unit_price,
  cash_discount,
  volume_discount,
  trading_discount,
  transportation_charge,
  insurance_charge,
  other_charge,
  product_id,
  uom_code,
  product_type,
  product_code,
  fob_point,
  ship_to_party_number,
  ship_to_party_name,
  ship_from_party_number,
  ship_from_party_name,
  ship_to_loc_id,
  ship_to_geography_type1,
  ship_to_geography_value1,
  ship_to_geography_type2,
  ship_to_geography_value2,
  ship_to_geography_type3,
  ship_to_geography_value3,
  ship_to_geography_type4,
  ship_to_geography_value4,
  ship_to_geography_type5,
  ship_to_geography_value5,
  ship_to_geography_type6,
  ship_to_geography_value6,
  ship_to_geography_type7,
  ship_to_geography_value7,
  ship_to_geography_type8,
  ship_to_geography_value8,
  ship_to_geography_type9,
  ship_to_geography_value9,
  ship_to_geography_type10,
  ship_to_geography_value10,
  ship_from_loc_id,
  ship_from_geography_type1,
  ship_from_geography_value1,
  ship_from_geography_type2,
  ship_from_geography_value2,
  ship_from_geography_type3,
  ship_from_geography_value3,
  ship_from_geography_type4,
  ship_from_geography_value4,
  ship_from_geography_type5,
  ship_from_geography_value5,
  ship_from_geography_type6,
  ship_from_geography_value6,
  ship_from_geography_type7,
  ship_from_geography_value7,
  ship_from_geography_type8,
  ship_from_geography_value8,
  ship_from_geography_type9,
  ship_from_geography_value9,
  ship_from_geography_type10,
  ship_from_geography_value10,
  poa_loc_id,
  poa_geography_type1,
  poa_geography_value1,
  poa_geography_type2,
  poa_geography_value2,
  poa_geography_type3,
  poa_geography_value3,
  poa_geography_type4,
  poa_geography_value4,
  poa_geography_type5,
  poa_geography_value5,
  poa_geography_type6,
  poa_geography_value6,
  poa_geography_type7,
  poa_geography_value7,
  poa_geography_type8,
  poa_geography_value8,
  poa_geography_type9,
  poa_geography_value9,
  poa_geography_type10,
  poa_geography_value10,
  poo_loc_id,
  poo_geography_type1,
  poo_geography_value1,
  poo_geography_type2,
  poo_geography_value2,
  poo_geography_type3,
  poo_geography_value3,
  poo_geography_type4,
  poo_geography_value4,
  poo_geography_type5,
  poo_geography_value5,
  poo_geography_type6,
  poo_geography_value6,
  poo_geography_type7,
  poo_geography_value7,
  poo_geography_type8,
  poo_geography_value8,
  poo_geography_type9,
  poo_geography_value9,
  poo_geography_type10,
  poo_geography_value10,
  bill_to_party_number,
  bill_to_party_name,
  bill_from_party_number,
  bill_from_party_name,
  bill_to_loc_id,
  bill_to_geography_type1,
  bill_to_geography_value1,
  bill_to_geography_type2,
  bill_to_geography_value2,
  bill_to_geography_type3,
  bill_to_geography_value3,
  bill_to_geography_type4,
  bill_to_geography_value4,
  bill_to_geography_type5,
  bill_to_geography_value5,
  bill_to_geography_type6,
  bill_to_geography_value6,
  bill_to_geography_type7,
  bill_to_geography_value7,
  bill_to_geography_type8,
  bill_to_geography_value8,
  bill_to_geography_type9,
  bill_to_geography_value9,
  bill_to_geography_type10,
  bill_to_geography_value10,
  bill_from_loc_id,
  bill_from_geography_type1,
  bill_from_geography_value1,
  bill_from_geography_type2,
  bill_from_geography_value2,
  bill_from_geography_type3,
  bill_from_geography_value3,
  bill_from_geography_type4,
  bill_from_geography_value4,
  bill_from_geography_type5,
  bill_from_geography_value5,
  bill_from_geography_type6,
  bill_from_geography_value6,
  bill_from_geography_type7,
  bill_from_geography_value7,
  bill_from_geography_type8,
  bill_from_geography_value8,
  bill_from_geography_type9,
  bill_from_geography_value9,
  bill_from_geography_type10,
  bill_from_geography_value10,
  account_ccid,
  APPLIED_FROM_DOCUMENT_TYPE_ID,
  applied_from_transaction_id,
  applied_from_line_id,
  applied_from_trx_level_type,
  APPLIED_FROM_DOC_NUMBER,
  ADJUSTED_DOC_DOCUMENT_TYPE_ID,
  adjusted_doc_transaction_id,
  adjusted_doc_line_id,
  adjusted_doc_trx_level_type,
  adjusted_doc_number,
  adjusted_doc_date,
  assessable_value,
  trx_line_number,
  trx_line_description,
  product_description,
  header_char1,
  header_char2,
  header_char3,
  header_char4,
  header_char5,
  header_char6,
  header_char7,
  header_char8,
  header_char9,
  header_char10,
  header_char11,
  header_char12,
  header_char13,
  header_char14,
  header_char15,
  header_char16,
  header_char17,
  header_char18,
  header_char19,
  header_char20,
  header_char21,
  header_char22,
  header_char23,
  header_char24,
  header_char25,
  header_char26,
  header_char27,
  header_char28,
  header_char29,
  header_char30,
  header_numeric1,
  header_numeric2,
  header_numeric3,
  header_numeric4,
  header_numeric5,
  header_numeric6,
  header_numeric7,
  header_numeric8,
  header_numeric9,
  header_numeric10,
  header_date1,
  header_date2,
  header_date3,
  header_date4,
  header_date5,
  line_char1,
  line_char2,
  line_char3,
  line_char4,
  line_char5,
  line_char6,
  line_char7,
  line_char8,
  line_char9,
  line_char10,
  line_char11,
  line_char12,
  line_char13,
  line_char14,
  line_char15,
  line_char16,
  line_char17,
  line_char18,
  line_char19,
  line_char20,
  line_char21,
  line_char22,
  line_char23,
  line_char24,
  line_char25,
  line_char26,
  line_char27,
  line_char28,
  line_char29,
  line_char30,
  line_numeric1,
  line_numeric2,
  line_numeric3,
  line_numeric4,
  line_numeric5,
  line_numeric6,
  line_numeric7,
  line_numeric8,
  line_numeric9,
  line_numeric10,
  line_date1,
  line_date2,
  line_date3,
  line_date4,
  line_date5,
  EXEMPT_CERTIFICATE_NUMBER,
  EXEMPT_REASON ,
  EXEMPTION_CONTROL_FLAG
FROM
(SELECT
  zldf.internal_organization_id,
  zldf.event_class_mapping_id document_type_id,
  zldf.trx_id transaction_id,
  ztppo.application_short_name application_code,
  zldf.tax_event_type_code document_level_action,
  zldf.trx_date,
  zldf.trx_currency_code,
/*Bug 5090593   ztppo.quote_flag, */
  ztppo.legal_entity_number,
  ztppo.establishment_number,
  zldf.trx_number transaction_number,
  zldf.trx_description transaction_description,
  zldf.doc_seq_value document_sequence_value,
  zldf.trx_due_date transaction_due_date,
/*Bug 5090593   zldf.record_type_code, */
  ztppo.allow_tax_calculation_flag allow_tax_calculation,
  zldf.trx_line_id transaction_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, /* line_level_action */
  zldf.line_class,
  zldf.trx_shipping_date transaction_shipping_date,
  zldf.trx_receipt_date transaction_receipt_date,
  zldf.trx_line_type transaction_line_type,
  zldf.trx_line_date transaction_line_date,
  zldf.provnl_tax_determination_date, /*Bug 5090593 */
  NVL(zldf.trx_business_category, ztppo.event_class_code) trx_business_category,
  zldf.line_intended_use,
  DECODE (zldf.line_amt_includes_tax_flag, 'I','A', line_amt_includes_tax_flag) line_amt_includes_tax_flag,
  zldf.line_amt line_amount,
  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_inclusive_tax_amount, /* other_incl_tax_amt */
  zldf.trx_line_quantity transaction_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 ship_to_loc_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 ship_from_loc_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 poa_loc_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 poo_loc_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 bill_to_loc_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 bill_from_loc_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, /* applied from document type id Bug 5090593: Applied to_number function */
  zldf.applied_from_trx_id applied_from_transaction_id,
  zldf.applied_from_line_id,
  zldf.applied_from_trx_level_type,
  zldf.applied_from_trx_number APPLIED_FROM_DOC_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, /* adjusted doc document type id */
  zldf.adjusted_doc_trx_id adjusted_doc_transaction_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 header_char1,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE2 header_char2,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE3 header_char3,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE4 header_char4,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE5 header_char5,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE6 header_char6,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE7 header_char7,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE8 header_char8,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE9 header_char9,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE10 header_char10,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE11 header_char11,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE12 header_char12,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE13 header_char13,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE14 header_char14,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE15 header_char15,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE16 header_char16,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE17 header_char17,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE18 header_char18,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE19 header_char19,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE20 header_char20,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE21 header_char21,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE22 header_char22,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE23 header_char23,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE24 header_char24,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE25 header_char25,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE26 header_char26,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE27 header_char27,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE28 header_char28,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE29 header_char29,
  zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE30 header_char30,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE1 header_numeric1,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE2 header_numeric2,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE3 header_numeric3,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE4 header_numeric4,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE5 header_numeric5,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE6 header_numeric6,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE7 header_numeric7,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE8 header_numeric8,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE9 header_numeric9,
  zpshea.HEADER_EXT_NUMBER_ATTRIBUTE10 header_numeric10,
  zpshea.HEADER_EXT_DATE_ATTRIBUTE1 header_date1,
  zpshea.HEADER_EXT_DATE_ATTRIBUTE2 header_date2,
  zpshea.HEADER_EXT_DATE_ATTRIBUTE3 header_date3,
  zpshea.HEADER_EXT_DATE_ATTRIBUTE4 header_date4,
  zpshea.HEADER_EXT_DATE_ATTRIBUTE5 header_date5,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE1 line_char1,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE2 line_char2,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE3 line_char3,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE4 line_char4,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE5 line_char5,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE6 line_char6,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE7 line_char7,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE8 line_char8,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE9 line_char9,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE10 line_char10,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE11 line_char11,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE12 line_char12,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE13 line_char13,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE14 line_char14,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE15 line_char15,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE16 line_char16,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE17 line_char17,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE18 line_char18,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE19 line_char19,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE20 line_char20,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE21 line_char21,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE22 line_char22,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE23 line_char23,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE24 line_char24,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE25 line_char25,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE26 line_char26,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE27 line_char27,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE28 line_char28,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE29 line_char29,
  zpslea.LINE_EXT_VARCHAR_ATTRIBUTE30 line_char30,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE1 line_numeric1,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE2 line_numeric2,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE3 line_numeric3,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE4 line_numeric4,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE5 line_numeric5,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE6 line_numeric6,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE7 line_numeric7,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE8 line_numeric8,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE9 line_numeric9,
  zpslea.LINE_EXT_NUMBER_ATTRIBUTE10 line_numeric10,
  zpslea.LINE_EXT_DATE_ATTRIBUTE1 line_date1,
  zpslea.LINE_EXT_DATE_ATTRIBUTE2 line_date2,
  zpslea.LINE_EXT_DATE_ATTRIBUTE3 line_date3,
  zpslea.LINE_EXT_DATE_ATTRIBUTE4 line_date4,
  zpslea.LINE_EXT_DATE_ATTRIBUTE5 line_date5,
  zldf.EXEMPT_CERTIFICATE_NUMBER,
  zldf.EXEMPT_REASON ,
  zldf.EXEMPTION_CONTROL_FLAG,
  --bug#7247830
  Decode(NVL(zldf.output_tax_classification_code, zldf.input_tax_classification_code),
                NULL,'LOCATION',
                (SELECT zx.tax_type_code FROM zx_sco_taxes zx,zx_sco_rates zr
	              WHERE zx.tax = zr.tax
	              AND zx.tax_regime_code = zr.tax_regime_code
                AND zx.live_for_processing_flag = 'Y'
	              AND zr.tax_rate_code = NVL(zldf.output_tax_classification_code, zldf.input_tax_classification_code)
	              AND (tax_type_code = 'LOCATION' OR (tax_type_code = 'SALES_TAX'
                           AND (tax_rate_code = 'STATE' OR tax_rate_code = 'COUNTY' OR tax_rate_code = 'CITY'
                                 OR tax_rate_code LIKE '%_COUNTY' OR tax_rate_code LIKE '%_CITY')))
                AND rownum = 1)) tax_type_code,
  NVL(ra.tax_calculation_flag,'Y') tax_calculation_flag,
  NVL(zldf.output_tax_classification_code, zldf.input_tax_classification_code) tax_code
  --bug#7247830
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,
  --bug#7247830
  RA_CUST_TRX_TYPES_ALL ra
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
  --bug#7247830
  AND ra.cust_trx_type_id(+) = zldf.receivables_trx_type_id
  AND ra.org_id(+) = zldf.internal_organization_id
  --bug#7247830
  /*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' )))
--bug#7247830
WHERE (tax_calculation_flag = 'Y'
       OR (tax_calculation_flag = 'N' AND tax_code IS NOT NULL))
  AND tax_type_code IS NOT NULL

View Text - HTML Formatted

SELECT --BUG#7247830 INTERNAL_ORGANIZATION_ID
, DOCUMENT_TYPE_ID
, TRANSACTION_ID
, APPLICATION_CODE
, DOCUMENT_LEVEL_ACTION
, TRX_DATE
, TRX_CURRENCY_CODE
, LEGAL_ENTITY_NUMBER
, ESTABLISHMENT_NUMBER
, TRANSACTION_NUMBER
, TRANSACTION_DESCRIPTION
, DOCUMENT_SEQUENCE_VALUE
, TRANSACTION_DUE_DATE
, ALLOW_TAX_CALCULATION
, TRANSACTION_LINE_ID
, TRX_LEVEL_TYPE
, LINE_LEVEL_ACTION
, LINE_CLASS
, TRANSACTION_SHIPPING_DATE
, TRANSACTION_RECEIPT_DATE
, TRANSACTION_LINE_TYPE
, TRANSACTION_LINE_DATE
, PROVNL_TAX_DETERMINATION_DATE
, TRX_BUSINESS_CATEGORY
, LINE_INTENDED_USE
, LINE_AMT_INCLUDES_TAX_FLAG
, LINE_AMOUNT
, OTHER_INCLUSIVE_TAX_AMOUNT
, TRANSACTION_LINE_QUANTITY
, UNIT_PRICE
, CASH_DISCOUNT
, VOLUME_DISCOUNT
, TRADING_DISCOUNT
, TRANSPORTATION_CHARGE
, INSURANCE_CHARGE
, OTHER_CHARGE
, PRODUCT_ID
, UOM_CODE
, PRODUCT_TYPE
, PRODUCT_CODE
, FOB_POINT
, SHIP_TO_PARTY_NUMBER
, SHIP_TO_PARTY_NAME
, SHIP_FROM_PARTY_NUMBER
, SHIP_FROM_PARTY_NAME
, SHIP_TO_LOC_ID
, SHIP_TO_GEOGRAPHY_TYPE1
, SHIP_TO_GEOGRAPHY_VALUE1
, SHIP_TO_GEOGRAPHY_TYPE2
, SHIP_TO_GEOGRAPHY_VALUE2
, SHIP_TO_GEOGRAPHY_TYPE3
, SHIP_TO_GEOGRAPHY_VALUE3
, SHIP_TO_GEOGRAPHY_TYPE4
, SHIP_TO_GEOGRAPHY_VALUE4
, SHIP_TO_GEOGRAPHY_TYPE5
, SHIP_TO_GEOGRAPHY_VALUE5
, SHIP_TO_GEOGRAPHY_TYPE6
, SHIP_TO_GEOGRAPHY_VALUE6
, SHIP_TO_GEOGRAPHY_TYPE7
, SHIP_TO_GEOGRAPHY_VALUE7
, SHIP_TO_GEOGRAPHY_TYPE8
, SHIP_TO_GEOGRAPHY_VALUE8
, SHIP_TO_GEOGRAPHY_TYPE9
, SHIP_TO_GEOGRAPHY_VALUE9
, SHIP_TO_GEOGRAPHY_TYPE10
, SHIP_TO_GEOGRAPHY_VALUE10
, SHIP_FROM_LOC_ID
, SHIP_FROM_GEOGRAPHY_TYPE1
, SHIP_FROM_GEOGRAPHY_VALUE1
, SHIP_FROM_GEOGRAPHY_TYPE2
, SHIP_FROM_GEOGRAPHY_VALUE2
, SHIP_FROM_GEOGRAPHY_TYPE3
, SHIP_FROM_GEOGRAPHY_VALUE3
, SHIP_FROM_GEOGRAPHY_TYPE4
, SHIP_FROM_GEOGRAPHY_VALUE4
, SHIP_FROM_GEOGRAPHY_TYPE5
, SHIP_FROM_GEOGRAPHY_VALUE5
, SHIP_FROM_GEOGRAPHY_TYPE6
, SHIP_FROM_GEOGRAPHY_VALUE6
, SHIP_FROM_GEOGRAPHY_TYPE7
, SHIP_FROM_GEOGRAPHY_VALUE7
, SHIP_FROM_GEOGRAPHY_TYPE8
, SHIP_FROM_GEOGRAPHY_VALUE8
, SHIP_FROM_GEOGRAPHY_TYPE9
, SHIP_FROM_GEOGRAPHY_VALUE9
, SHIP_FROM_GEOGRAPHY_TYPE10
, SHIP_FROM_GEOGRAPHY_VALUE10
, POA_LOC_ID
, POA_GEOGRAPHY_TYPE1
, POA_GEOGRAPHY_VALUE1
, POA_GEOGRAPHY_TYPE2
, POA_GEOGRAPHY_VALUE2
, POA_GEOGRAPHY_TYPE3
, POA_GEOGRAPHY_VALUE3
, POA_GEOGRAPHY_TYPE4
, POA_GEOGRAPHY_VALUE4
, POA_GEOGRAPHY_TYPE5
, POA_GEOGRAPHY_VALUE5
, POA_GEOGRAPHY_TYPE6
, POA_GEOGRAPHY_VALUE6
, POA_GEOGRAPHY_TYPE7
, POA_GEOGRAPHY_VALUE7
, POA_GEOGRAPHY_TYPE8
, POA_GEOGRAPHY_VALUE8
, POA_GEOGRAPHY_TYPE9
, POA_GEOGRAPHY_VALUE9
, POA_GEOGRAPHY_TYPE10
, POA_GEOGRAPHY_VALUE10
, POO_LOC_ID
, POO_GEOGRAPHY_TYPE1
, POO_GEOGRAPHY_VALUE1
, POO_GEOGRAPHY_TYPE2
, POO_GEOGRAPHY_VALUE2
, POO_GEOGRAPHY_TYPE3
, POO_GEOGRAPHY_VALUE3
, POO_GEOGRAPHY_TYPE4
, POO_GEOGRAPHY_VALUE4
, POO_GEOGRAPHY_TYPE5
, POO_GEOGRAPHY_VALUE5
, POO_GEOGRAPHY_TYPE6
, POO_GEOGRAPHY_VALUE6
, POO_GEOGRAPHY_TYPE7
, POO_GEOGRAPHY_VALUE7
, POO_GEOGRAPHY_TYPE8
, POO_GEOGRAPHY_VALUE8
, POO_GEOGRAPHY_TYPE9
, POO_GEOGRAPHY_VALUE9
, POO_GEOGRAPHY_TYPE10
, POO_GEOGRAPHY_VALUE10
, BILL_TO_PARTY_NUMBER
, BILL_TO_PARTY_NAME
, BILL_FROM_PARTY_NUMBER
, BILL_FROM_PARTY_NAME
, BILL_TO_LOC_ID
, BILL_TO_GEOGRAPHY_TYPE1
, BILL_TO_GEOGRAPHY_VALUE1
, BILL_TO_GEOGRAPHY_TYPE2
, BILL_TO_GEOGRAPHY_VALUE2
, BILL_TO_GEOGRAPHY_TYPE3
, BILL_TO_GEOGRAPHY_VALUE3
, BILL_TO_GEOGRAPHY_TYPE4
, BILL_TO_GEOGRAPHY_VALUE4
, BILL_TO_GEOGRAPHY_TYPE5
, BILL_TO_GEOGRAPHY_VALUE5
, BILL_TO_GEOGRAPHY_TYPE6
, BILL_TO_GEOGRAPHY_VALUE6
, BILL_TO_GEOGRAPHY_TYPE7
, BILL_TO_GEOGRAPHY_VALUE7
, BILL_TO_GEOGRAPHY_TYPE8
, BILL_TO_GEOGRAPHY_VALUE8
, BILL_TO_GEOGRAPHY_TYPE9
, BILL_TO_GEOGRAPHY_VALUE9
, BILL_TO_GEOGRAPHY_TYPE10
, BILL_TO_GEOGRAPHY_VALUE10
, BILL_FROM_LOC_ID
, BILL_FROM_GEOGRAPHY_TYPE1
, BILL_FROM_GEOGRAPHY_VALUE1
, BILL_FROM_GEOGRAPHY_TYPE2
, BILL_FROM_GEOGRAPHY_VALUE2
, BILL_FROM_GEOGRAPHY_TYPE3
, BILL_FROM_GEOGRAPHY_VALUE3
, BILL_FROM_GEOGRAPHY_TYPE4
, BILL_FROM_GEOGRAPHY_VALUE4
, BILL_FROM_GEOGRAPHY_TYPE5
, BILL_FROM_GEOGRAPHY_VALUE5
, BILL_FROM_GEOGRAPHY_TYPE6
, BILL_FROM_GEOGRAPHY_VALUE6
, BILL_FROM_GEOGRAPHY_TYPE7
, BILL_FROM_GEOGRAPHY_VALUE7
, BILL_FROM_GEOGRAPHY_TYPE8
, BILL_FROM_GEOGRAPHY_VALUE8
, BILL_FROM_GEOGRAPHY_TYPE9
, BILL_FROM_GEOGRAPHY_VALUE9
, BILL_FROM_GEOGRAPHY_TYPE10
, BILL_FROM_GEOGRAPHY_VALUE10
, ACCOUNT_CCID
, APPLIED_FROM_DOCUMENT_TYPE_ID
, APPLIED_FROM_TRANSACTION_ID
, APPLIED_FROM_LINE_ID
, APPLIED_FROM_TRX_LEVEL_TYPE
, APPLIED_FROM_DOC_NUMBER
, ADJUSTED_DOC_DOCUMENT_TYPE_ID
, ADJUSTED_DOC_TRANSACTION_ID
, ADJUSTED_DOC_LINE_ID
, ADJUSTED_DOC_TRX_LEVEL_TYPE
, ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE
, ASSESSABLE_VALUE
, TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION
, PRODUCT_DESCRIPTION
, HEADER_CHAR1
, HEADER_CHAR2
, HEADER_CHAR3
, HEADER_CHAR4
, HEADER_CHAR5
, HEADER_CHAR6
, HEADER_CHAR7
, HEADER_CHAR8
, HEADER_CHAR9
, HEADER_CHAR10
, HEADER_CHAR11
, HEADER_CHAR12
, HEADER_CHAR13
, HEADER_CHAR14
, HEADER_CHAR15
, HEADER_CHAR16
, HEADER_CHAR17
, HEADER_CHAR18
, HEADER_CHAR19
, HEADER_CHAR20
, HEADER_CHAR21
, HEADER_CHAR22
, HEADER_CHAR23
, HEADER_CHAR24
, HEADER_CHAR25
, HEADER_CHAR26
, HEADER_CHAR27
, HEADER_CHAR28
, HEADER_CHAR29
, HEADER_CHAR30
, HEADER_NUMERIC1
, HEADER_NUMERIC2
, HEADER_NUMERIC3
, HEADER_NUMERIC4
, HEADER_NUMERIC5
, HEADER_NUMERIC6
, HEADER_NUMERIC7
, HEADER_NUMERIC8
, HEADER_NUMERIC9
, HEADER_NUMERIC10
, HEADER_DATE1
, HEADER_DATE2
, HEADER_DATE3
, HEADER_DATE4
, HEADER_DATE5
, LINE_CHAR1
, LINE_CHAR2
, LINE_CHAR3
, LINE_CHAR4
, LINE_CHAR5
, LINE_CHAR6
, LINE_CHAR7
, LINE_CHAR8
, LINE_CHAR9
, LINE_CHAR10
, LINE_CHAR11
, LINE_CHAR12
, LINE_CHAR13
, LINE_CHAR14
, LINE_CHAR15
, LINE_CHAR16
, LINE_CHAR17
, LINE_CHAR18
, LINE_CHAR19
, LINE_CHAR20
, LINE_CHAR21
, LINE_CHAR22
, LINE_CHAR23
, LINE_CHAR24
, LINE_CHAR25
, LINE_CHAR26
, LINE_CHAR27
, LINE_CHAR28
, LINE_CHAR29
, LINE_CHAR30
, LINE_NUMERIC1
, LINE_NUMERIC2
, LINE_NUMERIC3
, LINE_NUMERIC4
, LINE_NUMERIC5
, LINE_NUMERIC6
, LINE_NUMERIC7
, LINE_NUMERIC8
, LINE_NUMERIC9
, LINE_NUMERIC10
, LINE_DATE1
, LINE_DATE2
, LINE_DATE3
, LINE_DATE4
, LINE_DATE5
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON
, EXEMPTION_CONTROL_FLAG FROM (SELECT ZLDF.INTERNAL_ORGANIZATION_ID
, ZLDF.EVENT_CLASS_MAPPING_ID DOCUMENT_TYPE_ID
, ZLDF.TRX_ID TRANSACTION_ID
, ZTPPO.APPLICATION_SHORT_NAME APPLICATION_CODE
, ZLDF.TAX_EVENT_TYPE_CODE DOCUMENT_LEVEL_ACTION
, ZLDF.TRX_DATE
, ZLDF.TRX_CURRENCY_CODE
, /*BUG 5090593 ZTPPO.QUOTE_FLAG
, */ ZTPPO.LEGAL_ENTITY_NUMBER
, ZTPPO.ESTABLISHMENT_NUMBER
, ZLDF.TRX_NUMBER TRANSACTION_NUMBER
, ZLDF.TRX_DESCRIPTION TRANSACTION_DESCRIPTION
, ZLDF.DOC_SEQ_VALUE DOCUMENT_SEQUENCE_VALUE
, ZLDF.TRX_DUE_DATE TRANSACTION_DUE_DATE
, /*BUG 5090593 ZLDF.RECORD_TYPE_CODE
, */ ZTPPO.ALLOW_TAX_CALCULATION_FLAG ALLOW_TAX_CALCULATION
, ZLDF.TRX_LINE_ID TRANSACTION_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
, /* LINE_LEVEL_ACTION */ ZLDF.LINE_CLASS
, ZLDF.TRX_SHIPPING_DATE TRANSACTION_SHIPPING_DATE
, ZLDF.TRX_RECEIPT_DATE TRANSACTION_RECEIPT_DATE
, ZLDF.TRX_LINE_TYPE TRANSACTION_LINE_TYPE
, ZLDF.TRX_LINE_DATE TRANSACTION_LINE_DATE
, ZLDF.PROVNL_TAX_DETERMINATION_DATE
, /*BUG 5090593 */ NVL(ZLDF.TRX_BUSINESS_CATEGORY
, ZTPPO.EVENT_CLASS_CODE) TRX_BUSINESS_CATEGORY
, ZLDF.LINE_INTENDED_USE
, DECODE (ZLDF.LINE_AMT_INCLUDES_TAX_FLAG
, 'I'
, 'A'
, LINE_AMT_INCLUDES_TAX_FLAG) LINE_AMT_INCLUDES_TAX_FLAG
, ZLDF.LINE_AMT LINE_AMOUNT
, 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_INCLUSIVE_TAX_AMOUNT
, /* OTHER_INCL_TAX_AMT */ ZLDF.TRX_LINE_QUANTITY TRANSACTION_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 SHIP_TO_LOC_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 SHIP_FROM_LOC_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 POA_LOC_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 POO_LOC_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 BILL_TO_LOC_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 BILL_FROM_LOC_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
, /* APPLIED
FROM DOCUMENT TYPE ID BUG 5090593: APPLIED TO_NUMBER FUNCTION */ ZLDF.APPLIED_FROM_TRX_ID APPLIED_FROM_TRANSACTION_ID
, ZLDF.APPLIED_FROM_LINE_ID
, ZLDF.APPLIED_FROM_TRX_LEVEL_TYPE
, ZLDF.APPLIED_FROM_TRX_NUMBER APPLIED_FROM_DOC_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
, /* ADJUSTED DOC DOCUMENT TYPE ID */ ZLDF.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRANSACTION_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 HEADER_CHAR1
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE2 HEADER_CHAR2
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE3 HEADER_CHAR3
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE4 HEADER_CHAR4
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE5 HEADER_CHAR5
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE6 HEADER_CHAR6
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE7 HEADER_CHAR7
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE8 HEADER_CHAR8
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE9 HEADER_CHAR9
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE10 HEADER_CHAR10
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE11 HEADER_CHAR11
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE12 HEADER_CHAR12
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE13 HEADER_CHAR13
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE14 HEADER_CHAR14
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE15 HEADER_CHAR15
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE16 HEADER_CHAR16
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE17 HEADER_CHAR17
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE18 HEADER_CHAR18
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE19 HEADER_CHAR19
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE20 HEADER_CHAR20
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE21 HEADER_CHAR21
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE22 HEADER_CHAR22
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE23 HEADER_CHAR23
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE24 HEADER_CHAR24
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE25 HEADER_CHAR25
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE26 HEADER_CHAR26
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE27 HEADER_CHAR27
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE28 HEADER_CHAR28
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE29 HEADER_CHAR29
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE30 HEADER_CHAR30
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE1 HEADER_NUMERIC1
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE2 HEADER_NUMERIC2
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE3 HEADER_NUMERIC3
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE4 HEADER_NUMERIC4
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE5 HEADER_NUMERIC5
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE6 HEADER_NUMERIC6
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE7 HEADER_NUMERIC7
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE8 HEADER_NUMERIC8
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE9 HEADER_NUMERIC9
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE10 HEADER_NUMERIC10
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE1 HEADER_DATE1
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE2 HEADER_DATE2
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE3 HEADER_DATE3
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE4 HEADER_DATE4
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE5 HEADER_DATE5
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE1 LINE_CHAR1
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE2 LINE_CHAR2
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE3 LINE_CHAR3
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE4 LINE_CHAR4
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE5 LINE_CHAR5
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE6 LINE_CHAR6
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE7 LINE_CHAR7
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE8 LINE_CHAR8
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE9 LINE_CHAR9
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE10 LINE_CHAR10
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE11 LINE_CHAR11
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE12 LINE_CHAR12
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE13 LINE_CHAR13
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE14 LINE_CHAR14
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE15 LINE_CHAR15
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE16 LINE_CHAR16
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE17 LINE_CHAR17
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE18 LINE_CHAR18
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE19 LINE_CHAR19
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE20 LINE_CHAR20
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE21 LINE_CHAR21
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE22 LINE_CHAR22
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE23 LINE_CHAR23
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE24 LINE_CHAR24
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE25 LINE_CHAR25
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE26 LINE_CHAR26
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE27 LINE_CHAR27
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE28 LINE_CHAR28
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE29 LINE_CHAR29
, ZPSLEA.LINE_EXT_VARCHAR_ATTRIBUTE30 LINE_CHAR30
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE1 LINE_NUMERIC1
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE2 LINE_NUMERIC2
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE3 LINE_NUMERIC3
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE4 LINE_NUMERIC4
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE5 LINE_NUMERIC5
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE6 LINE_NUMERIC6
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE7 LINE_NUMERIC7
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE8 LINE_NUMERIC8
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE9 LINE_NUMERIC9
, ZPSLEA.LINE_EXT_NUMBER_ATTRIBUTE10 LINE_NUMERIC10
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE1 LINE_DATE1
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE2 LINE_DATE2
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE3 LINE_DATE3
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE4 LINE_DATE4
, ZPSLEA.LINE_EXT_DATE_ATTRIBUTE5 LINE_DATE5
, ZLDF.EXEMPT_CERTIFICATE_NUMBER
, ZLDF.EXEMPT_REASON
, ZLDF.EXEMPTION_CONTROL_FLAG
, --BUG#7247830 DECODE(NVL(ZLDF.OUTPUT_TAX_CLASSIFICATION_CODE
, ZLDF.INPUT_TAX_CLASSIFICATION_CODE)
, NULL
, 'LOCATION'
, (SELECT ZX.TAX_TYPE_CODE
FROM ZX_SCO_TAXES ZX
, ZX_SCO_RATES ZR
WHERE ZX.TAX = ZR.TAX
AND ZX.TAX_REGIME_CODE = ZR.TAX_REGIME_CODE
AND ZX.LIVE_FOR_PROCESSING_FLAG = 'Y'
AND ZR.TAX_RATE_CODE = NVL(ZLDF.OUTPUT_TAX_CLASSIFICATION_CODE
, ZLDF.INPUT_TAX_CLASSIFICATION_CODE)
AND (TAX_TYPE_CODE = 'LOCATION' OR (TAX_TYPE_CODE = 'SALES_TAX'
AND (TAX_RATE_CODE = 'STATE' OR TAX_RATE_CODE = 'COUNTY' OR TAX_RATE_CODE = 'CITY' OR TAX_RATE_CODE LIKE '%_COUNTY' OR TAX_RATE_CODE LIKE '%_CITY')))
AND ROWNUM = 1)) TAX_TYPE_CODE
, NVL(RA.TAX_CALCULATION_FLAG
, 'Y') TAX_CALCULATION_FLAG
, NVL(ZLDF.OUTPUT_TAX_CLASSIFICATION_CODE
, ZLDF.INPUT_TAX_CLASSIFICATION_CODE) TAX_CODE --BUG#7247830 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
, --BUG#7247830 RA_CUST_TRX_TYPES_ALL RA 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 --BUG#7247830
AND RA.CUST_TRX_TYPE_ID(+) = ZLDF.RECEIVABLES_TRX_TYPE_ID
AND RA.ORG_ID(+) = ZLDF.INTERNAL_ORGANIZATION_ID --BUG#7247830 /*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' ))) --BUG#7247830 WHERE (TAX_CALCULATION_FLAG = 'Y' OR (TAX_CALCULATION_FLAG = 'N'
AND TAX_CODE IS NOT NULL))
AND TAX_TYPE_CODE IS NOT NULL