Wednesday, 7 February 2024

Oracle EBS - SQL Query to get the employee default expense account

 

SELECT

    concatenated_segments
FROM
    apps.gl_code_combinations_kfv
WHERE
    code_combination_id IN (
        SELECT DISTINCT
            default_code_comb_id
        FROM
            apps.per_all_assignments_f
            WHERE  effective_end_date >= sysdate
        AND
            person_id IN (
                SELECT
                    person_id
                FROM
                    apps.per_all_people_f
                WHERE
                    effective_end_date >= sysdate
                    and person_id LIKE '&person_id'
            )
    );

No comments:

Post a Comment