VIEW: APPS.PER_BUDGETS_LOV

Source

View Text - Preformatted

SELECT B.NAME , HR1.MEANING , B.UNIT , B.BUDGET_ID , B.PERIOD_SET_NAME , B.BUSINESS_GROUP_ID , BV1.VERSION_NUMBER , BV1.BUDGET_VERSION_ID , BV1.DATE_FROM , NVL(BV1.DATE_TO,TO_DATE('31-12-4712','DD-MM-YYYY')) DATE_TO , BE.POSITION_ID , BE.ORGANIZATION_ID FROM PER_BUDGETS B, HR_LOOKUPS HR1, PER_BUDGET_VERSIONS BV1, PER_BUDGET_ELEMENTS BE, FND_SESSIONS FND WHERE HR1.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE' AND HR1.LOOKUP_CODE (+) = B.UNIT AND FND.EFFECTIVE_DATE BETWEEN NVL (HR1.START_DATE_ACTIVE, FND.EFFECTIVE_DATE) AND NVL (HR1.END_DATE_ACTIVE, FND.EFFECTIVE_DATE) AND HR1.ENABLED_FLAG = 'Y' AND BV1.BUDGET_VERSION_ID = BE.BUDGET_VERSION_ID AND BV1.BUDGET_ID = B.BUDGET_ID AND B.BUDGET_TYPE_CODE = 'HR_BUDGET' AND FND.SESSION_ID = USERENV('SESSIONID')

View Text - HTML Formatted

SELECT B.NAME
, HR1.MEANING
, B.UNIT
, B.BUDGET_ID
, B.PERIOD_SET_NAME
, B.BUSINESS_GROUP_ID
, BV1.VERSION_NUMBER
, BV1.BUDGET_VERSION_ID
, BV1.DATE_FROM
, NVL(BV1.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY')) DATE_TO
, BE.POSITION_ID
, BE.ORGANIZATION_ID
FROM PER_BUDGETS B
, HR_LOOKUPS HR1
, PER_BUDGET_VERSIONS BV1
, PER_BUDGET_ELEMENTS BE
, FND_SESSIONS FND
WHERE HR1.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE'
AND HR1.LOOKUP_CODE (+) = B.UNIT
AND FND.EFFECTIVE_DATE BETWEEN NVL (HR1.START_DATE_ACTIVE
, FND.EFFECTIVE_DATE)
AND NVL (HR1.END_DATE_ACTIVE
, FND.EFFECTIVE_DATE)
AND HR1.ENABLED_FLAG = 'Y'
AND BV1.BUDGET_VERSION_ID = BE.BUDGET_VERSION_ID
AND BV1.BUDGET_ID = B.BUDGET_ID
AND B.BUDGET_TYPE_CODE = 'HR_BUDGET'
AND FND.SESSION_ID = USERENV('SESSIONID')