VIEW: APPS.PAY_RUN_TYPE_ORG_METHODS_V

Source

View Text - Preformatted

SELECT ROM.RUN_TYPE_ORG_METHOD_ID , ROM.EFFECTIVE_START_DATE , ROM.EFFECTIVE_END_DATE , ROM.PRIORITY , ROM.PERCENTAGE , ROM.AMOUNT , ROM.OBJECT_VERSION_NUMBER , ROM.RUN_TYPE_ID , PRT_TL.RUN_TYPE_NAME , ROM.ORG_PAYMENT_METHOD_ID , OPM_TL.ORG_PAYMENT_METHOD_NAME , OPM.CURRENCY_CODE ,SUBSTR(HR_GENERAL.DECODE_LOOKUP('PAYMENT_CATEGORY', PPT.CATEGORY),1,80) ORG_PAYMENT_METHOD_TYPE , ROM.BUSINESS_GROUP_ID , ROM.LEGISLATION_CODE , ROM.ROWID ROW_ID FROM PAY_RUN_TYPE_ORG_METHODS_F ROM , PAY_RUN_TYPES_F PRT , PAY_RUN_TYPES_F_TL PRT_TL , PAY_ORG_PAYMENT_METHODS_F OPM , PAY_ORG_PAYMENT_METHODS_F_TL OPM_TL , PAY_PAYMENT_TYPES PPT , FND_SESSIONS FS WHERE ROM.RUN_TYPE_ID = PRT.RUN_TYPE_ID AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID AND PRT_TL.LANGUAGE = userenv('LANG') AND ROM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.ORG_PAYMENT_METHOD_ID = OPM_TL.ORG_PAYMENT_METHOD_ID AND OPM_TL.LANGUAGE = userenv('LANG') AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND FS.SESSION_ID = userenv('sessionid') AND FS.EFFECTIVE_DATE BETWEEN ROM.EFFECTIVE_START_DATE AND ROM.EFFECTIVE_END_DATE AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE AND PRT.EFFECTIVE_END_DATE AND FS.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ROM.RUN_TYPE_ORG_METHOD_ID
, ROM.EFFECTIVE_START_DATE
, ROM.EFFECTIVE_END_DATE
, ROM.PRIORITY
, ROM.PERCENTAGE
, ROM.AMOUNT
, ROM.OBJECT_VERSION_NUMBER
, ROM.RUN_TYPE_ID
, PRT_TL.RUN_TYPE_NAME
, ROM.ORG_PAYMENT_METHOD_ID
, OPM_TL.ORG_PAYMENT_METHOD_NAME
, OPM.CURRENCY_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('PAYMENT_CATEGORY'
, PPT.CATEGORY)
, 1
, 80) ORG_PAYMENT_METHOD_TYPE
, ROM.BUSINESS_GROUP_ID
, ROM.LEGISLATION_CODE
, ROM.ROWID ROW_ID
FROM PAY_RUN_TYPE_ORG_METHODS_F ROM
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F_TL PRT_TL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPM_TL
, PAY_PAYMENT_TYPES PPT
, FND_SESSIONS FS
WHERE ROM.RUN_TYPE_ID = PRT.RUN_TYPE_ID
AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID
AND PRT_TL.LANGUAGE = USERENV('LANG')
AND ROM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.ORG_PAYMENT_METHOD_ID = OPM_TL.ORG_PAYMENT_METHOD_ID
AND OPM_TL.LANGUAGE = USERENV('LANG')
AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN ROM.EFFECTIVE_START_DATE
AND ROM.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE