DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on GL_CODE_COMBINATIONS_KFV

Line 1476: FROM gl_code_combinations_kfv a, org_organization_definitions b

1472: OPEN x_accounts FOR
1473: SELECT a.code_combination_id
1474: , a.concatenated_segments
1475: , a.chart_of_accounts_id
1476: FROM gl_code_combinations_kfv a, org_organization_definitions b
1477: WHERE b.organization_id = p_organization_id
1478: AND a.chart_of_accounts_id = b.chart_of_accounts_id
1479: AND a.concatenated_segments LIKE (p_concatenated_segments)
1480: AND a.enabled_flag = 'Y'

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

1496: -- and in MSCA QUERY MO Page, Account LOV shows multiple times the same
1497: -- a/c segments which is incorrect. Hence this distinct.
1498: SELECT DISTINCT a.code_combination_id
1499: , a.concatenated_segments
1500: FROM gl_code_combinations_kfv a, org_organization_definitions b, mtl_txn_request_lines c
1501: WHERE c.header_id = p_moheader_id
1502: AND b.organization_id = p_organization_id
1503: AND a.chart_of_accounts_id = b.chart_of_accounts_id
1504: AND c.to_account_id = a.code_combination_id