VIEW: APPS.PAY_PERSONAL_PAY_METHODS_LOV

Source

View Text - Preformatted

SELECT OPMTL.ORG_PAYMENT_METHOD_NAME , OPM.ORG_PAYMENT_METHOD_ID , OPM.CURRENCY_CODE , OPM.DEFINED_BALANCE_ID , PTTL.PAYMENT_TYPE_NAME , PT.TERRITORY_CODE , PT.CATEGORY , PT.PRE_VALIDATION_REQUIRED , OPM.EFFECTIVE_END_DATE , USG.PAYROLL_ID , OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , TERR.TERRITORY_SHORT_NAME , PEA.ID_FLEX_NUM , FF.EFFECTIVE_DATE , PT.PAYMENT_TYPE_NAME FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL, PAY_PAYMENT_TYPES_TL PTTL, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_ORG_PAY_METHOD_USAGES_F USG, PAY_PAYMENT_TYPES PT, FND_TERRITORIES_VL TERR, PAY_EXTERNAL_ACCOUNTS PEA, FND_SESSIONS FF 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 FF.SESSION_ID = USERENV('SESSIONID') AND FF.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND FF.EFFECTIVE_DATE BETWEEN USG.EFFECTIVE_START_DATE AND USG.EFFECTIVE_END_DATE AND USG.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+) AND OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+)

View Text - HTML Formatted

SELECT OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.ORG_PAYMENT_METHOD_ID
, OPM.CURRENCY_CODE
, OPM.DEFINED_BALANCE_ID
, PTTL.PAYMENT_TYPE_NAME
, PT.TERRITORY_CODE
, PT.CATEGORY
, PT.PRE_VALIDATION_REQUIRED
, OPM.EFFECTIVE_END_DATE
, USG.PAYROLL_ID
, OPM.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, TERR.TERRITORY_SHORT_NAME
, PEA.ID_FLEX_NUM
, FF.EFFECTIVE_DATE
, PT.PAYMENT_TYPE_NAME
FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PAYMENT_TYPES_TL PTTL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAY_METHOD_USAGES_F USG
, PAY_PAYMENT_TYPES PT
, FND_TERRITORIES_VL TERR
, PAY_EXTERNAL_ACCOUNTS PEA
, FND_SESSIONS FF
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 FF.SESSION_ID = USERENV('SESSIONID')
AND FF.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND FF.EFFECTIVE_DATE BETWEEN USG.EFFECTIVE_START_DATE
AND USG.EFFECTIVE_END_DATE
AND USG.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+)
AND OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+)