VIEW: APPS.PAY_COST_ALLOCATIONS_V

Source

View Text - Preformatted

SELECT PAY.ROWID ROW_ID , PAY.COST_ALLOCATION_ID , PAY.EFFECTIVE_START_DATE , PAY.EFFECTIVE_END_DATE , PAY.BUSINESS_GROUP_ID , PAY.COST_ALLOCATION_KEYFLEX_ID , PAY.ASSIGNMENT_ID , PAY.PROPORTION , PAY.REQUEST_ID , PAY.PROGRAM_APPLICATION_ID , PAY.PROGRAM_ID , PAY.PROGRAM_UPDATE_DATE , PAY.LAST_UPDATE_DATE , PAY.LAST_UPDATED_BY , PAY.LAST_UPDATE_LOGIN , PAY.CREATED_BY , PAY.CREATION_DATE , PCAF.CONCATENATED_SEGMENTS, PAY.OBJECT_VERSION_NUMBER FROM FND_SESSIONS FND, PAY_COST_ALLOCATION_KEYFLEX PCAF, PAY_COST_ALLOCATIONS_F PAY WHERE PCAF.COST_ALLOCATION_KEYFLEX_ID (+) = PAY.COST_ALLOCATION_KEYFLEX_ID AND FND.SESSION_ID = USERENV('sessionid') AND FND.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PAY.ROWID ROW_ID
, PAY.COST_ALLOCATION_ID
, PAY.EFFECTIVE_START_DATE
, PAY.EFFECTIVE_END_DATE
, PAY.BUSINESS_GROUP_ID
, PAY.COST_ALLOCATION_KEYFLEX_ID
, PAY.ASSIGNMENT_ID
, PAY.PROPORTION
, PAY.REQUEST_ID
, PAY.PROGRAM_APPLICATION_ID
, PAY.PROGRAM_ID
, PAY.PROGRAM_UPDATE_DATE
, PAY.LAST_UPDATE_DATE
, PAY.LAST_UPDATED_BY
, PAY.LAST_UPDATE_LOGIN
, PAY.CREATED_BY
, PAY.CREATION_DATE
, PCAF.CONCATENATED_SEGMENTS
, PAY.OBJECT_VERSION_NUMBER
FROM FND_SESSIONS FND
, PAY_COST_ALLOCATION_KEYFLEX PCAF
, PAY_COST_ALLOCATIONS_F PAY
WHERE PCAF.COST_ALLOCATION_KEYFLEX_ID (+) = PAY.COST_ALLOCATION_KEYFLEX_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE