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 = '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 = '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','CREATE','ALLOCATE_TAX_ONLY_ADJUSTMENT','CREATE','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','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,
appecm.event_class_mapping_id, /* applied from document type id */
zldf.applied_from_trx_id,
zldf.applied_from_line_id,
zldf.applied_from_trx_level_type,
zldf.applied_from_trx_number,
adjecm.event_class_mapping_id, /* 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
/* Other Documents Joins */
AND zldf.applied_from_application_id = appecm.application_id
AND zldf.applied_from_entity_code = appecm.entity_code
AND zldf.applied_from_event_class_code = appecm.event_class_code
AND zldf.adjusted_doc_application_id = adjecm.application_id
AND zldf.adjusted_doc_entity_code = adjecm.entity_code
AND zldf.adjusted_doc_event_class_code = adjecm.event_class_code
/* 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 zldf.line_level_action <> 'LINE_INFO_TAX_ONLY'
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' )
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 = '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 = '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'
, 'CREATE'
, 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
, 'CREATE'
, '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'
, '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
,
APPECM.EVENT_CLASS_MAPPING_ID
, /* APPLIED
FROM DOCUMENT TYPE ID */
ZLDF.APPLIED_FROM_TRX_ID
,
ZLDF.APPLIED_FROM_LINE_ID
,
ZLDF.APPLIED_FROM_TRX_LEVEL_TYPE
,
ZLDF.APPLIED_FROM_TRX_NUMBER
,
ADJECM.EVENT_CLASS_MAPPING_ID
, /* 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
/* OTHER DOCUMENTS JOINS */
AND ZLDF.APPLIED_FROM_APPLICATION_ID = APPECM.APPLICATION_ID
AND ZLDF.APPLIED_FROM_ENTITY_CODE = APPECM.ENTITY_CODE
AND ZLDF.APPLIED_FROM_EVENT_CLASS_CODE = APPECM.EVENT_CLASS_CODE
AND ZLDF.ADJUSTED_DOC_APPLICATION_ID = ADJECM.APPLICATION_ID
AND ZLDF.ADJUSTED_DOC_ENTITY_CODE = ADJECM.ENTITY_CODE
AND ZLDF.ADJUSTED_DOC_EVENT_CLASS_CODE = ADJECM.EVENT_CLASS_CODE
/* 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 ZLDF.LINE_LEVEL_ACTION <> 'LINE_INFO_TAX_ONLY'
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' )
|
|
|