VIEW: APPS.HR_H2PI_COST_ALLOCATIONS_V

Source

View Text - Preformatted

SELECT coa.last_update_date, coa.business_group_id, coa.cost_allocation_id, asg.person_id, coa.effective_start_date, coa.effective_end_date, coa.assignment_id, coa.proportion, cak.concatenated_segments, cak.id_flex_num, cak.summary_flag, cak.enabled_flag, cak.start_date_active, cak.end_date_active, cak.segment1, cak.segment2, cak.segment3, cak.segment4, cak.segment5, cak.segment6, cak.segment7, cak.segment8, cak.segment9, cak.segment10, cak.segment11, cak.segment12, cak.segment13, cak.segment14, cak.segment15, cak.segment16, cak.segment17, cak.segment18, cak.segment19, cak.segment20, cak.segment21, cak.segment22, cak.segment23, cak.segment24, cak.segment25, cak.segment26, cak.segment27, cak.segment28, cak.segment29, cak.segment30 from pay_cost_allocations_f coa, pay_cost_allocation_keyflex cak, hr_h2pi_assignments_v asg WHERE coa.cost_allocation_keyflex_id = cak.cost_allocation_keyflex_id and asg.assignment_id = coa.assignment_id and coa.effective_start_date between asg.effective_start_date and asg.effective_end_date

View Text - HTML Formatted

SELECT COA.LAST_UPDATE_DATE
, COA.BUSINESS_GROUP_ID
, COA.COST_ALLOCATION_ID
, ASG.PERSON_ID
, COA.EFFECTIVE_START_DATE
, COA.EFFECTIVE_END_DATE
, COA.ASSIGNMENT_ID
, COA.PROPORTION
, CAK.CONCATENATED_SEGMENTS
, CAK.ID_FLEX_NUM
, CAK.SUMMARY_FLAG
, CAK.ENABLED_FLAG
, CAK.START_DATE_ACTIVE
, CAK.END_DATE_ACTIVE
, CAK.SEGMENT1
, CAK.SEGMENT2
, CAK.SEGMENT3
, CAK.SEGMENT4
, CAK.SEGMENT5
, CAK.SEGMENT6
, CAK.SEGMENT7
, CAK.SEGMENT8
, CAK.SEGMENT9
, CAK.SEGMENT10
, CAK.SEGMENT11
, CAK.SEGMENT12
, CAK.SEGMENT13
, CAK.SEGMENT14
, CAK.SEGMENT15
, CAK.SEGMENT16
, CAK.SEGMENT17
, CAK.SEGMENT18
, CAK.SEGMENT19
, CAK.SEGMENT20
, CAK.SEGMENT21
, CAK.SEGMENT22
, CAK.SEGMENT23
, CAK.SEGMENT24
, CAK.SEGMENT25
, CAK.SEGMENT26
, CAK.SEGMENT27
, CAK.SEGMENT28
, CAK.SEGMENT29
, CAK.SEGMENT30
FROM PAY_COST_ALLOCATIONS_F COA
, PAY_COST_ALLOCATION_KEYFLEX CAK
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE COA.COST_ALLOCATION_KEYFLEX_ID = CAK.COST_ALLOCATION_KEYFLEX_ID
AND ASG.ASSIGNMENT_ID = COA.ASSIGNMENT_ID
AND COA.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE