431: pp.full_name,
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(+)
452: pp.full_name,
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(+)