VIEW: APPS.AP_RECURRING_PAYMENTS_V

Source

View Text - Preformatted

SELECT ARP.ROWID ROW_ID , ARP.ACCOUNTING_DATE ACCOUNTING_DATE , ARP.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID , ARP.AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT , ARP.APPROVED_BY APPROVED_BY , ARP.ATTRIBUTE1 ATTRIBUTE1 , ARP.ATTRIBUTE10 ATTRIBUTE10 , ARP.ATTRIBUTE11 ATTRIBUTE11 , ARP.ATTRIBUTE12 ATTRIBUTE12 , ARP.ATTRIBUTE13 ATTRIBUTE13 , ARP.ATTRIBUTE14 ATTRIBUTE14 , ARP.ATTRIBUTE15 ATTRIBUTE15 , ARP.ATTRIBUTE2 ATTRIBUTE2 , ARP.ATTRIBUTE3 ATTRIBUTE3 , ARP.ATTRIBUTE4 ATTRIBUTE4 , ARP.ATTRIBUTE5 ATTRIBUTE5 , ARP.ATTRIBUTE6 ATTRIBUTE6 , ARP.ATTRIBUTE7 ATTRIBUTE7 , ARP.ATTRIBUTE8 ATTRIBUTE8 , ARP.ATTRIBUTE9 ATTRIBUTE9 , ARP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , ARP.AUTHORIZED_TOTAL AUTHORIZED_TOTAL , ARP.AWT_GROUP_ID AWT_GROUP_ID , ARP.BATCH_ID BATCH_ID , ARP.CONTROL_AMOUNT CONTROL_AMOUNT , ARP.CREATED_BY CREATED_BY , ARP.CREATION_DATE CREATION_DATE , ARP.DESCRIPTION DESCRIPTION , ARP.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID , ARP.EXCHANGE_DATE EXCHANGE_DATE , ARP.EXCHANGE_RATE EXCHANGE_RATE , ARP.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE , ARP.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG , ARP.EXPIRY_DATE EXPIRY_DATE , ARP.FIRST_PERIOD FIRST_PERIOD , ARP.FIRST_PERIOD_NUM FIRST_PERIOD_NUM , ARP.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE , ARP.HOLD_REASON HOLD_REASON , ARP.INCREMENT_PERCENT INCREMENT_PERCENT , ARP.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE , ARP.LAST_UPDATED_BY LAST_UPDATED_BY , ARP.LAST_UPDATE_DATE LAST_UPDATE_DATE , ARP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ARP.NEXT_PAYMENT NEXT_PAYMENT , ARP.NEXT_PERIOD NEXT_PERIOD , ARP.NUM_OF_PERIODS NUM_OF_PERIODS , ARP.NUM_OF_PERIODS_REM NUM_OF_PERIODS_REM , ARP.ORG_ID ORG_ID , ARP.PAID_FLAG1 PAID_FLAG1 , ARP.PAID_FLAG2 PAID_FLAG2 , ARP.PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE , ARP.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE , ARP.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE , ARP.RECURRING_PAYMENT_ID RECURRING_PAYMENT_ID , ARP.RECURRING_PAY_NUM RECURRING_PAY_NUM , ARP.REC_PAY_PERIOD_TYPE REC_PAY_PERIOD_TYPE , ARP.RELEASED_AMOUNT RELEASED_AMOUNT , ARP.REM_PERIODS REM_PERIODS , ARP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID , ARP.SPECIAL_PAYMENT_AMOUNT1 SPECIAL_PAYMENT_AMOUNT1 , ARP.SPECIAL_PAYMENT_AMOUNT2 SPECIAL_PAYMENT_AMOUNT2 , ARP.SPECIAL_PERIOD_NAME1 SPECIAL_PERIOD_NAME1 , ARP.SPECIAL_PERIOD_NAME2 SPECIAL_PERIOD_NAME2 , ARP.TAX_AMOUNT TAX_AMOUNT , ARP.TAX_NAME TAX_NAME , ARP.TERMS_ID TERMS_ID , ARP.VENDOR_ID VENDOR_ID , ARP.VENDOR_SITE_ID VENDOR_SITE_ID , ARP.PO_HEADER_ID PO_HEADER_ID , ARP.PO_LINE_ID PO_LINE_ID , ARP.LINE_LOCATION_ID LINE_LOCATION_ID , PV.VENDOR_NAME VENDOR_NAME , PV.SEGMENT1 VENDOR_NUMBER , PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE , DECODE(PVS.HOLD_FUTURE_PAYMENTS_FLAG, 'Y', 'VENDOR', NULL) INVOICE_HOLD_CODE , PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY , PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT , PVS.STATE STATE , ALC1.DISPLAYED_FIELD HOLD_DSP , AT.NAME TERMS , ADS.DISTRIBUTION_SET_NAME DISTRIBUTION_SET , PH.SEGMENT1 PO_NUMBER , PL.LINE_NUM LINE_NUM , PLL.SHIPMENT_NUM SHIPMENT_NUM , AWT.NAME AWT_GROUP_NAME , PV.ALLOW_AWT_FLAG VENDOR_ALLOW_AWT_FLAG , PVS.ALLOW_AWT_FLAG SITE_ALLOW_AWT_FLAG , ARP.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY , ARP.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1 , ARP.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2 , ARP.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3 , ARP.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4 , ARP.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5 , ARP.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6 , ARP.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7 , ARP.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8 , ARP.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9 , ARP.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10 , ARP.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11 , ARP.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12 , ARP.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13 , ARP.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14 , ARP.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15 , ARP.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16 , ARP.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17 , ARP.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18 , ARP.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19 , ARP.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20 , ARP.EXTERNAL_BANK_ACCOUNT_ID , IPB.BANK_ACCOUNT_NAME , IPB.BANK_NAME , IPB.BANK_NUMBER , IPB.BRANCH_NUMBER , IPB.BRANCH_NAME , IPB.BANK_ACCOUNT_NUM , ARP.APPROVAL_REQUIRED_FLAG , ARP.REQUESTER_ID , ARP.PO_RELEASE_ID , PR.RELEASE_NUM , ARP.ITEM_DESCRIPTION , ARP.MANUFACTURER , ARP.MODEL_NUMBER , PH.TYPE_LOOKUP_CODE , ARP.TAXATION_COUNTRY , ARP.TAX_CONTROL_AMOUNT , ARP.PRIMARY_INTENDED_USE , ARP.PRODUCT_FISC_CLASSIFICATION , ARP.USER_DEFINED_FISC_CLASS , ARP.TRX_BUSINESS_CATEGORY , ARP.LEGAL_ENTITY_ID ,ARP.PAYMENT_METHOD_CODE ,IBY1.PAYMENT_METHOD_NAME ,ARP.PAYMENT_REASON_CODE ,IBY2.meaning ,ARP.REMITTANCE_MESSAGE1 ,ARP.REMITTANCE_MESSAGE2 ,ARP.REMITTANCE_MESSAGE3 ,PV.PARTY_ID ,PVS.PARTY_SITE_ID ,ARP.BANK_CHARGE_BEARER ,IBY3.MEANING ,ARP.SETTLEMENT_PRIORITY ,IBY5.MEANING ,ARP.PAYMENT_REASON_COMMENTS ,ARP.DELIVERY_CHANNEL_CODE ,IBY4.MEANING ,ARP.first_amount ,PVS.exclude_freight_from_discount /* bug 4931755 */ ,ARP.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID ,AWT1.NAME PAY_AWT_GROUP_NAME /* Bug 7535348*/ ,NVL(ARP.REMIT_TO_SUPPLIER_NAME, PV.VENDOR_NAME) REMIT_TO_SUPPLIER_NAME ,NVL(ARP.REMIT_TO_SUPPLIER_ID, ARP.VENDOR_ID) REMIT_TO_SUPPLIER_ID ,NVL(ARP.REMIT_TO_SUPPLIER_SITE, PVS.VENDOR_SITE_CODE) REMIT_TO_SUPPLIER_SITE ,NVL(ARP.REMIT_TO_SUPPLIER_SITE_ID, ARP.VENDOR_SITE_ID) REMIT_TO_SUPPLIER_SITE_ID ,NVL(ARP.RELATIONSHIP_ID, -1) RELATIONSHIP_ID /* Bug 7535348*/ FROM AP_RECURRING_PAYMENTS ARP, AP_SUPPLIERS PV, AP_SUPPLIER_SITES_ALL PVS, AP_LOOKUP_CODES ALC1, AP_TERMS AT, AP_DISTRIBUTION_SETS_ALL ADS, PO_HEADERS_ALL PH, PO_RELEASES_ALL PR, PO_LINES_ALL PL, PO_LINE_LOCATIONS_ALL PLL, AP_AWT_GROUPS AWT, AP_AWT_GROUPS AWT1, IBY_PAYEE_ALL_BANKACCT_V IPB, /* External Bank Accounts Uptake */ iby_payment_methods_vl iby1, iby_payment_reasons_vl iby2, fnd_lookups iby3, fnd_lookups iby5, iby_delivery_channels_vl iby4 WHERE ARP.VENDOR_ID = PV.VENDOR_ID (+) AND ARP.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+) AND ARP.DELIVERY_CHANNEL_CODE = IBY4.DELIVERY_CHANNEL_CODE(+) AND ARP.SETTLEMENT_PRIORITY = IBY5.LOOKUP_CODE (+) AND IBY5.LOOKUP_TYPE (+) = 'IBY_SETTLEMENT_PRIORITY' AND IBY3.LOOKUP_TYPE (+) = 'IBY_BANK_CHARGE_BEARER' AND ARP.BANK_CHARGE_BEARER = IBY3.LOOKUP_CODE(+) AND ALC1.LOOKUP_TYPE (+) = 'HOLD CODE' AND ALC1.LOOKUP_CODE (+) = ARP.HOLD_LOOKUP_CODE AND ARP.TERMS_ID = AT.TERM_ID (+) AND ARP.DISTRIBUTION_SET_ID = ADS.DISTRIBUTION_SET_ID (+) AND ARP.PO_HEADER_ID = PH.PO_HEADER_ID (+) AND ARP.PO_RELEASE_ID = PR.PO_RELEASE_ID (+) AND ARP.PO_LINE_ID = PL.PO_LINE_ID (+) AND ARP.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID (+) AND ARP.AWT_GROUP_ID = AWT.GROUP_ID (+) AND ARP.PAY_AWT_GROUP_ID=AWT1.GROUP_ID(+) AND ARP.EXTERNAL_BANK_ACCOUNT_ID = IPB.EXT_BANK_ACCOUNT_ID (+) AND ARP.PAYMENT_METHOD_CODE = IBY1.PAYMENT_METHOD_CODE (+) AND ARP.PAYMENT_REASON_CODE = IBY2.PAYMENT_REASON_CODE (+)

View Text - HTML Formatted

SELECT ARP.ROWID ROW_ID
, ARP.ACCOUNTING_DATE ACCOUNTING_DATE
, ARP.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, ARP.AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT
, ARP.APPROVED_BY APPROVED_BY
, ARP.ATTRIBUTE1 ATTRIBUTE1
, ARP.ATTRIBUTE10 ATTRIBUTE10
, ARP.ATTRIBUTE11 ATTRIBUTE11
, ARP.ATTRIBUTE12 ATTRIBUTE12
, ARP.ATTRIBUTE13 ATTRIBUTE13
, ARP.ATTRIBUTE14 ATTRIBUTE14
, ARP.ATTRIBUTE15 ATTRIBUTE15
, ARP.ATTRIBUTE2 ATTRIBUTE2
, ARP.ATTRIBUTE3 ATTRIBUTE3
, ARP.ATTRIBUTE4 ATTRIBUTE4
, ARP.ATTRIBUTE5 ATTRIBUTE5
, ARP.ATTRIBUTE6 ATTRIBUTE6
, ARP.ATTRIBUTE7 ATTRIBUTE7
, ARP.ATTRIBUTE8 ATTRIBUTE8
, ARP.ATTRIBUTE9 ATTRIBUTE9
, ARP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ARP.AUTHORIZED_TOTAL AUTHORIZED_TOTAL
, ARP.AWT_GROUP_ID AWT_GROUP_ID
, ARP.BATCH_ID BATCH_ID
, ARP.CONTROL_AMOUNT CONTROL_AMOUNT
, ARP.CREATED_BY CREATED_BY
, ARP.CREATION_DATE CREATION_DATE
, ARP.DESCRIPTION DESCRIPTION
, ARP.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, ARP.EXCHANGE_DATE EXCHANGE_DATE
, ARP.EXCHANGE_RATE EXCHANGE_RATE
, ARP.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, ARP.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, ARP.EXPIRY_DATE EXPIRY_DATE
, ARP.FIRST_PERIOD FIRST_PERIOD
, ARP.FIRST_PERIOD_NUM FIRST_PERIOD_NUM
, ARP.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, ARP.HOLD_REASON HOLD_REASON
, ARP.INCREMENT_PERCENT INCREMENT_PERCENT
, ARP.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, ARP.LAST_UPDATED_BY LAST_UPDATED_BY
, ARP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ARP.NEXT_PAYMENT NEXT_PAYMENT
, ARP.NEXT_PERIOD NEXT_PERIOD
, ARP.NUM_OF_PERIODS NUM_OF_PERIODS
, ARP.NUM_OF_PERIODS_REM NUM_OF_PERIODS_REM
, ARP.ORG_ID ORG_ID
, ARP.PAID_FLAG1 PAID_FLAG1
, ARP.PAID_FLAG2 PAID_FLAG2
, ARP.PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE
, ARP.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, ARP.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, ARP.RECURRING_PAYMENT_ID RECURRING_PAYMENT_ID
, ARP.RECURRING_PAY_NUM RECURRING_PAY_NUM
, ARP.REC_PAY_PERIOD_TYPE REC_PAY_PERIOD_TYPE
, ARP.RELEASED_AMOUNT RELEASED_AMOUNT
, ARP.REM_PERIODS REM_PERIODS
, ARP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ARP.SPECIAL_PAYMENT_AMOUNT1 SPECIAL_PAYMENT_AMOUNT1
, ARP.SPECIAL_PAYMENT_AMOUNT2 SPECIAL_PAYMENT_AMOUNT2
, ARP.SPECIAL_PERIOD_NAME1 SPECIAL_PERIOD_NAME1
, ARP.SPECIAL_PERIOD_NAME2 SPECIAL_PERIOD_NAME2
, ARP.TAX_AMOUNT TAX_AMOUNT
, ARP.TAX_NAME TAX_NAME
, ARP.TERMS_ID TERMS_ID
, ARP.VENDOR_ID VENDOR_ID
, ARP.VENDOR_SITE_ID VENDOR_SITE_ID
, ARP.PO_HEADER_ID PO_HEADER_ID
, ARP.PO_LINE_ID PO_LINE_ID
, ARP.LINE_LOCATION_ID LINE_LOCATION_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, DECODE(PVS.HOLD_FUTURE_PAYMENTS_FLAG
, 'Y'
, 'VENDOR'
, NULL) INVOICE_HOLD_CODE
, PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT
, PVS.STATE STATE
, ALC1.DISPLAYED_FIELD HOLD_DSP
, AT.NAME TERMS
, ADS.DISTRIBUTION_SET_NAME DISTRIBUTION_SET
, PH.SEGMENT1 PO_NUMBER
, PL.LINE_NUM LINE_NUM
, PLL.SHIPMENT_NUM SHIPMENT_NUM
, AWT.NAME AWT_GROUP_NAME
, PV.ALLOW_AWT_FLAG VENDOR_ALLOW_AWT_FLAG
, PVS.ALLOW_AWT_FLAG SITE_ALLOW_AWT_FLAG
, ARP.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, ARP.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, ARP.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, ARP.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, ARP.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, ARP.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, ARP.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, ARP.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, ARP.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, ARP.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, ARP.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, ARP.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, ARP.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, ARP.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, ARP.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, ARP.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, ARP.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, ARP.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, ARP.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, ARP.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, ARP.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ARP.EXTERNAL_BANK_ACCOUNT_ID
, IPB.BANK_ACCOUNT_NAME
, IPB.BANK_NAME
, IPB.BANK_NUMBER
, IPB.BRANCH_NUMBER
, IPB.BRANCH_NAME
, IPB.BANK_ACCOUNT_NUM
, ARP.APPROVAL_REQUIRED_FLAG
, ARP.REQUESTER_ID
, ARP.PO_RELEASE_ID
, PR.RELEASE_NUM
, ARP.ITEM_DESCRIPTION
, ARP.MANUFACTURER
, ARP.MODEL_NUMBER
, PH.TYPE_LOOKUP_CODE
, ARP.TAXATION_COUNTRY
, ARP.TAX_CONTROL_AMOUNT
, ARP.PRIMARY_INTENDED_USE
, ARP.PRODUCT_FISC_CLASSIFICATION
, ARP.USER_DEFINED_FISC_CLASS
, ARP.TRX_BUSINESS_CATEGORY
, ARP.LEGAL_ENTITY_ID
, ARP.PAYMENT_METHOD_CODE
, IBY1.PAYMENT_METHOD_NAME
, ARP.PAYMENT_REASON_CODE
, IBY2.MEANING
, ARP.REMITTANCE_MESSAGE1
, ARP.REMITTANCE_MESSAGE2
, ARP.REMITTANCE_MESSAGE3
, PV.PARTY_ID
, PVS.PARTY_SITE_ID
, ARP.BANK_CHARGE_BEARER
, IBY3.MEANING
, ARP.SETTLEMENT_PRIORITY
, IBY5.MEANING
, ARP.PAYMENT_REASON_COMMENTS
, ARP.DELIVERY_CHANNEL_CODE
, IBY4.MEANING
, ARP.FIRST_AMOUNT
, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT /* BUG 4931755 */
, ARP.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, AWT1.NAME PAY_AWT_GROUP_NAME /* BUG 7535348*/
, NVL(ARP.REMIT_TO_SUPPLIER_NAME
, PV.VENDOR_NAME) REMIT_TO_SUPPLIER_NAME
, NVL(ARP.REMIT_TO_SUPPLIER_ID
, ARP.VENDOR_ID) REMIT_TO_SUPPLIER_ID
, NVL(ARP.REMIT_TO_SUPPLIER_SITE
, PVS.VENDOR_SITE_CODE) REMIT_TO_SUPPLIER_SITE
, NVL(ARP.REMIT_TO_SUPPLIER_SITE_ID
, ARP.VENDOR_SITE_ID) REMIT_TO_SUPPLIER_SITE_ID
, NVL(ARP.RELATIONSHIP_ID
, -1) RELATIONSHIP_ID /* BUG 7535348*/
FROM AP_RECURRING_PAYMENTS ARP
, AP_SUPPLIERS PV
, AP_SUPPLIER_SITES_ALL PVS
, AP_LOOKUP_CODES ALC1
, AP_TERMS AT
, AP_DISTRIBUTION_SETS_ALL ADS
, PO_HEADERS_ALL PH
, PO_RELEASES_ALL PR
, PO_LINES_ALL PL
, PO_LINE_LOCATIONS_ALL PLL
, AP_AWT_GROUPS AWT
, AP_AWT_GROUPS AWT1
, IBY_PAYEE_ALL_BANKACCT_V IPB
, /* EXTERNAL BANK ACCOUNTS UPTAKE */ IBY_PAYMENT_METHODS_VL IBY1
, IBY_PAYMENT_REASONS_VL IBY2
, FND_LOOKUPS IBY3
, FND_LOOKUPS IBY5
, IBY_DELIVERY_CHANNELS_VL IBY4
WHERE ARP.VENDOR_ID = PV.VENDOR_ID (+)
AND ARP.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND ARP.DELIVERY_CHANNEL_CODE = IBY4.DELIVERY_CHANNEL_CODE(+)
AND ARP.SETTLEMENT_PRIORITY = IBY5.LOOKUP_CODE (+)
AND IBY5.LOOKUP_TYPE (+) = 'IBY_SETTLEMENT_PRIORITY'
AND IBY3.LOOKUP_TYPE (+) = 'IBY_BANK_CHARGE_BEARER'
AND ARP.BANK_CHARGE_BEARER = IBY3.LOOKUP_CODE(+)
AND ALC1.LOOKUP_TYPE (+) = 'HOLD CODE'
AND ALC1.LOOKUP_CODE (+) = ARP.HOLD_LOOKUP_CODE
AND ARP.TERMS_ID = AT.TERM_ID (+)
AND ARP.DISTRIBUTION_SET_ID = ADS.DISTRIBUTION_SET_ID (+)
AND ARP.PO_HEADER_ID = PH.PO_HEADER_ID (+)
AND ARP.PO_RELEASE_ID = PR.PO_RELEASE_ID (+)
AND ARP.PO_LINE_ID = PL.PO_LINE_ID (+)
AND ARP.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID (+)
AND ARP.AWT_GROUP_ID = AWT.GROUP_ID (+)
AND ARP.PAY_AWT_GROUP_ID=AWT1.GROUP_ID(+)
AND ARP.EXTERNAL_BANK_ACCOUNT_ID = IPB.EXT_BANK_ACCOUNT_ID (+)
AND ARP.PAYMENT_METHOD_CODE = IBY1.PAYMENT_METHOD_CODE (+)
AND ARP.PAYMENT_REASON_CODE = IBY2.PAYMENT_REASON_CODE (+)