DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on GL_CODE_COMBINATIONS_KFV

Line 1452: FROM gl_code_combinations_kfv a, org_organization_definitions b

1448: OPEN x_accounts FOR
1449: SELECT a.code_combination_id
1450: , a.concatenated_segments
1451: , a.chart_of_accounts_id
1452: FROM gl_code_combinations_kfv a, org_organization_definitions b
1453: WHERE b.organization_id = p_organization_id
1454: AND a.chart_of_accounts_id = b.chart_of_accounts_id
1455: AND a.concatenated_segments LIKE (p_concatenated_segments)
1456: AND a.enabled_flag = 'Y'

Line 1476: FROM gl_code_combinations_kfv a, org_organization_definitions b, mtl_txn_request_lines c

1472: -- and in MSCA QUERY MO Page, Account LOV shows multiple times the same
1473: -- a/c segments which is incorrect. Hence this distinct.
1474: SELECT DISTINCT a.code_combination_id
1475: , a.concatenated_segments
1476: FROM gl_code_combinations_kfv a, org_organization_definitions b, mtl_txn_request_lines c
1477: WHERE c.header_id = p_moheader_id
1478: AND b.organization_id = p_organization_id
1479: AND a.chart_of_accounts_id = b.chart_of_accounts_id
1480: AND c.to_account_id = a.code_combination_id