VIEW: APPS.PAY_ORG_PAYMENT_METHODS_V

Source

View Text - Preformatted

SELECT OPM.ORG_PAYMENT_METHOD_ID , OPM.ROWID ROW_ID , OPM.EFFECTIVE_START_DATE , DECODE(OPM.EFFECTIVE_END_DATE, fnd_date.canonical_to_date('4712/12/31'), NULL, OPM.EFFECTIVE_END_DATE) D_EFFECTIVE_END_DATE , OPM.EFFECTIVE_END_DATE , OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , OPM.EXTERNAL_ACCOUNT_ID , OPM.CURRENCY_CODE , CUR.NAME CURRENCY_NAME , OPM.PAYMENT_TYPE_ID , PTTL.PAYMENT_TYPE_NAME , NVL(PT.TERRITORY_CODE,BG.LEGISLATION_CODE) COUNTRY_CODE , TERR.TERRITORY_SHORT_NAME COUNTRY , PT.CATEGORY PAYMENT_TYPE_CATEGORY , OPM.DEFINED_BALANCE_ID , OPMTL.ORG_PAYMENT_METHOD_NAME , OPM.COMMENT_ID , OPM.ATTRIBUTE_CATEGORY , OPM.ATTRIBUTE1 , OPM.ATTRIBUTE2 , OPM.ATTRIBUTE3 , OPM.ATTRIBUTE4 , OPM.ATTRIBUTE5 , OPM.ATTRIBUTE6 , OPM.ATTRIBUTE7 , OPM.ATTRIBUTE8 , OPM.ATTRIBUTE9 , OPM.ATTRIBUTE10 , OPM.ATTRIBUTE11 , OPM.ATTRIBUTE12 , OPM.ATTRIBUTE13 , OPM.ATTRIBUTE14 , OPM.ATTRIBUTE15 , OPM.ATTRIBUTE16 , OPM.ATTRIBUTE17 , OPM.ATTRIBUTE18 , OPM.ATTRIBUTE19 , OPM.ATTRIBUTE20 , OPM.LAST_UPDATE_DATE , OPM.LAST_UPDATED_BY , OPM.LAST_UPDATE_LOGIN , OPM.CREATED_BY , OPM.CREATION_DATE , OPM.PMETH_INFORMATION_CATEGORY , OPM.PMETH_INFORMATION1 , OPM.PMETH_INFORMATION2 , OPM.PMETH_INFORMATION3 , OPM.PMETH_INFORMATION4 , OPM.PMETH_INFORMATION5 , OPM.PMETH_INFORMATION6 , OPM.PMETH_INFORMATION7 , OPM.PMETH_INFORMATION8 , OPM.PMETH_INFORMATION9 , OPM.PMETH_INFORMATION10 , OPM.PMETH_INFORMATION11 , OPM.PMETH_INFORMATION12 , OPM.PMETH_INFORMATION13 , OPM.PMETH_INFORMATION14 , OPM.PMETH_INFORMATION15 , OPM.PMETH_INFORMATION16 , OPM.PMETH_INFORMATION17 , OPM.PMETH_INFORMATION18 , OPM.PMETH_INFORMATION19 , OPM.PMETH_INFORMATION20 , OPM.ORG_PAYMENT_METHOD_NAME BASE_OPM_NAME , PT.PAYMENT_TYPE_NAME BASE_PAYMENT_TYPE_NAME , OPM.TRANSFER_TO_GL_FLAG, OPM.COST_PAYMENT , OPM.COST_CLEARED_PAYMENT , OPM.COST_CLEARED_VOID_PAYMENT , OPM.EXCLUDE_MANUAL_PAYMENT FROM FND_CURRENCIES_VL CUR , FND_TERRITORIES_VL TERR , FND_SESSIONS SES , PER_BUSINESS_GROUPS BG , PAY_BALANCE_DIMENSIONS BD , PAY_DEFINED_BALANCES DB , PAY_PAYMENT_TYPES_TL PTTL , PAY_PAYMENT_TYPES PT , PAY_ORG_PAYMENT_METHODS_F_TL OPMTL , PAY_ORG_PAYMENT_METHODS_F OPM WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID AND PTTL.LANGUAGE = userenv('LANG') AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = userenv('LANG') AND OPM.CURRENCY_CODE = CUR.CURRENCY_CODE AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID AND TERR.TERRITORY_CODE = NVL(PT.TERRITORY_CODE,BG.LEGISLATION_CODE) AND OPM.BUSINESS_GROUP_ID + 0 = BG.BUSINESS_GROUP_ID + 0 AND NVL(DB.BUSINESS_GROUP_ID, NVL(BG.BUSINESS_GROUP_ID, 0)) = NVL(BG.BUSINESS_GROUP_ID,0) AND NVL(DB.LEGISLATION_CODE, NVL(BG.LEGISLATION_CODE, ' ')) = NVL(BG.LEGISLATION_CODE, ' ') AND DB.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID (+) AND OPM.DEFINED_BALANCE_ID = DB.DEFINED_BALANCE_ID (+) AND BD.PAYMENTS_FLAG (+) = 'Y' AND SES.SESSION_ID = USERENV('sessionid') AND SES.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT OPM.ORG_PAYMENT_METHOD_ID
, OPM.ROWID ROW_ID
, OPM.EFFECTIVE_START_DATE
, DECODE(OPM.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31')
, NULL
, OPM.EFFECTIVE_END_DATE) D_EFFECTIVE_END_DATE
, OPM.EFFECTIVE_END_DATE
, OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, OPM.EXTERNAL_ACCOUNT_ID
, OPM.CURRENCY_CODE
, CUR.NAME CURRENCY_NAME
, OPM.PAYMENT_TYPE_ID
, PTTL.PAYMENT_TYPE_NAME
, NVL(PT.TERRITORY_CODE
, BG.LEGISLATION_CODE) COUNTRY_CODE
, TERR.TERRITORY_SHORT_NAME COUNTRY
, PT.CATEGORY PAYMENT_TYPE_CATEGORY
, OPM.DEFINED_BALANCE_ID
, OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.COMMENT_ID
, OPM.ATTRIBUTE_CATEGORY
, OPM.ATTRIBUTE1
, OPM.ATTRIBUTE2
, OPM.ATTRIBUTE3
, OPM.ATTRIBUTE4
, OPM.ATTRIBUTE5
, OPM.ATTRIBUTE6
, OPM.ATTRIBUTE7
, OPM.ATTRIBUTE8
, OPM.ATTRIBUTE9
, OPM.ATTRIBUTE10
, OPM.ATTRIBUTE11
, OPM.ATTRIBUTE12
, OPM.ATTRIBUTE13
, OPM.ATTRIBUTE14
, OPM.ATTRIBUTE15
, OPM.ATTRIBUTE16
, OPM.ATTRIBUTE17
, OPM.ATTRIBUTE18
, OPM.ATTRIBUTE19
, OPM.ATTRIBUTE20
, OPM.LAST_UPDATE_DATE
, OPM.LAST_UPDATED_BY
, OPM.LAST_UPDATE_LOGIN
, OPM.CREATED_BY
, OPM.CREATION_DATE
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION1
, OPM.PMETH_INFORMATION2
, OPM.PMETH_INFORMATION3
, OPM.PMETH_INFORMATION4
, OPM.PMETH_INFORMATION5
, OPM.PMETH_INFORMATION6
, OPM.PMETH_INFORMATION7
, OPM.PMETH_INFORMATION8
, OPM.PMETH_INFORMATION9
, OPM.PMETH_INFORMATION10
, OPM.PMETH_INFORMATION11
, OPM.PMETH_INFORMATION12
, OPM.PMETH_INFORMATION13
, OPM.PMETH_INFORMATION14
, OPM.PMETH_INFORMATION15
, OPM.PMETH_INFORMATION16
, OPM.PMETH_INFORMATION17
, OPM.PMETH_INFORMATION18
, OPM.PMETH_INFORMATION19
, OPM.PMETH_INFORMATION20
, OPM.ORG_PAYMENT_METHOD_NAME BASE_OPM_NAME
, PT.PAYMENT_TYPE_NAME BASE_PAYMENT_TYPE_NAME
, OPM.TRANSFER_TO_GL_FLAG
, OPM.COST_PAYMENT
, OPM.COST_CLEARED_PAYMENT
, OPM.COST_CLEARED_VOID_PAYMENT
, OPM.EXCLUDE_MANUAL_PAYMENT
FROM FND_CURRENCIES_VL CUR
, FND_TERRITORIES_VL TERR
, FND_SESSIONS SES
, PER_BUSINESS_GROUPS BG
, PAY_BALANCE_DIMENSIONS BD
, PAY_DEFINED_BALANCES DB
, PAY_PAYMENT_TYPES_TL PTTL
, PAY_PAYMENT_TYPES PT
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_ORG_PAYMENT_METHODS_F OPM
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND OPM.CURRENCY_CODE = CUR.CURRENCY_CODE
AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
AND TERR.TERRITORY_CODE = NVL(PT.TERRITORY_CODE
, BG.LEGISLATION_CODE)
AND OPM.BUSINESS_GROUP_ID + 0 = BG.BUSINESS_GROUP_ID + 0
AND NVL(DB.BUSINESS_GROUP_ID
, NVL(BG.BUSINESS_GROUP_ID
, 0)) = NVL(BG.BUSINESS_GROUP_ID
, 0)
AND NVL(DB.LEGISLATION_CODE
, NVL(BG.LEGISLATION_CODE
, ' ')) = NVL(BG.LEGISLATION_CODE
, ' ')
AND DB.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID (+)
AND OPM.DEFINED_BALANCE_ID = DB.DEFINED_BALANCE_ID (+)
AND BD.PAYMENTS_FLAG (+) = 'Y'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE