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