View: ZX_O2C_CALC_TXN_INPUT_V

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

View Text

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' ) )