432: fl.concatenated_segments location,
433: gcc.concatenated_segments ccid
434: FROM fa_distribution_inquiry_v fdi,
435: gl_code_combinations_kfv gcc,
436: per_people_x pp,
437: fa_locations_kfv fl
438: WHERE (transaction_header_id_key = v_row.transaction_header_id)
439: AND fdi.assigned_to = pp.person_id(+)
440: AND fdi.location_id = fl.location_id(+)
453: fl.concatenated_segments location,
454: gcc.concatenated_segments ccid
455: FROM fa_distribution_inquiry_v fdi,
456: gl_code_combinations_kfv gcc,
457: per_people_x pp,
458: fa_locations_kfv fl
459: WHERE (transaction_header_id_key = v_row.transaction_header_id)
460: AND fdi.assigned_to = pp.person_id(+)
461: AND fdi.location_id = fl.location_id(+)