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.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
, DECODE(PV.VENDOR_TYPE_LOOKUP_CODE,'EMPLOYEE', NVL((SELECT NVL(ALC.DISPLAYED_FIELD, PVS.VENDOR_SITE_CODE)
                                                     FROM AP_LOOKUP_CODES ALC
                                                     WHERE ALC.lookup_type(+) = 'VENDOR_SITE_CODE'
                                                     AND   ALC.lookup_code(+) = PVS.VENDOR_SITE_CODE),
                                                     PVS.VENDOR_SITE_CODE),
                                     PVS.VENDOR_SITE_CODE) VENDOR_SITE_CODE /* Bug 15966842 */
, 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
, NVL(PH.CLM_DOCUMENT_NUMBER, PH.SEGMENT1) PO_NUMBER       /*9481666 - CLM*/
, NVL(PL.LINE_NUM_DISPLAY, TO_CHAR(PL.LINE_NUM)) LINE_NUM  /*9481666 - CLM*/
, 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
, CBB.BANK_NAME  /*Bug10081741: changed aliases*/
, CBB.BANK_NUMBER /*Bug10081741: changed aliases*/
, CBB.BRANCH_NUMBER  /*Bug10081741: changed aliases*/
, CBB.BANK_BRANCH_NAME /*Bug10081741: changed aliases*/
/* IPB.BANK_ACCOUNT_NUM Modified this value for Bug#14496597 */
, IPB.MASKED_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  /*bug 7439828*/
,AWT1.NAME PAY_AWT_GROUP_NAME  /*bug 7439828*/
/* Bug 8345877 */
,ARP.REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME
,ARP.REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID
,ARP.REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE
,ARP.REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID
,ARP.RELATIONSHIP_ID RELATIONSHIP_ID	/* Bug 8345877 */
,ARP.PRODUCT_TYPE          /*Bug#8640313 */
,ARP.PRODUCT_CATEGORY      /*Bug#8640313 */ 
    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, /*bug 7439828*/ 
      iby_ext_bank_accounts IPB, /*Bug10081741*//* External Bank Accounts Uptake */ 
      CE_BANK_BRANCHES_V CBB,  /*Bug10081741*/
      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 (+) /*bug 7439828*/
   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 (+)
   AND IPB.BRANCH_ID = CBB.BRANCH_PARTY_ID(+) /*Bug10081741*/
   AND IPB.BANK_ID = CBB.BANK_PARTY_ID(+) /*Bug10081741*/

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
, DECODE(PV.VENDOR_TYPE_LOOKUP_CODE
, 'EMPLOYEE'
, NVL((SELECT NVL(ALC.DISPLAYED_FIELD
, PVS.VENDOR_SITE_CODE)
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE(+) = 'VENDOR_SITE_CODE'
AND ALC.LOOKUP_CODE(+) = PVS.VENDOR_SITE_CODE)
, PVS.VENDOR_SITE_CODE)
, PVS.VENDOR_SITE_CODE) VENDOR_SITE_CODE /* BUG 15966842 */
, 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
, NVL(PH.CLM_DOCUMENT_NUMBER
, PH.SEGMENT1) PO_NUMBER /*9481666 - CLM*/
, NVL(PL.LINE_NUM_DISPLAY
, TO_CHAR(PL.LINE_NUM)) LINE_NUM /*9481666 - CLM*/
, 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
, CBB.BANK_NAME /*BUG10081741: CHANGED ALIASES*/
, CBB.BANK_NUMBER /*BUG10081741: CHANGED ALIASES*/
, CBB.BRANCH_NUMBER /*BUG10081741: CHANGED ALIASES*/
, CBB.BANK_BRANCH_NAME /*BUG10081741: CHANGED ALIASES*/ /* IPB.BANK_ACCOUNT_NUM MODIFIED THIS VALUE FOR BUG#14496597 */
, IPB.MASKED_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 /*BUG 7439828*/
, AWT1.NAME PAY_AWT_GROUP_NAME /*BUG 7439828*/ /* BUG 8345877 */
, ARP.REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME
, ARP.REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID
, ARP.REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE
, ARP.REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID
, ARP.RELATIONSHIP_ID RELATIONSHIP_ID /* BUG 8345877 */
, ARP.PRODUCT_TYPE /*BUG#8640313 */
, ARP.PRODUCT_CATEGORY /*BUG#8640313 */
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
, /*BUG 7439828*/ IBY_EXT_BANK_ACCOUNTS IPB
, /*BUG10081741*//* EXTERNAL BANK ACCOUNTS UPTAKE */ CE_BANK_BRANCHES_V CBB
, /*BUG10081741*/ 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 (+) /*BUG 7439828*/
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 (+)
AND IPB.BRANCH_ID = CBB.BRANCH_PARTY_ID(+) /*BUG10081741*/
AND IPB.BANK_ID = CBB.BANK_PARTY_ID(+) /*BUG10081741*/