APPS.INV_INV_LOVS dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 650: FROM org_organization_definitions org, mtl_system_items msi

646: OPEN x_to_org_lov FOR
647: SELECT DISTINCT org.organization_id
648: , org.organization_code
649: , org.organization_name
650: FROM org_organization_definitions org, mtl_system_items msi
651: WHERE org.organization_id <> p_from_organization_id
652: AND org.organization_id = msi.organization_id
653: AND msi.inventory_item_id IN (SELECT inventory_item_id
654: FROM mtl_system_items

Line 684: FROM org_organization_definitions

680: /* SELECT DISTINCT organization_id
681: , organization_code
682: , organization_name
683: , 0
684: FROM org_organization_definitions
685: WHERE organization_code LIKE (p_organization_code)
686: ORDER BY 2; */
687: --Bug 2649387
688: SELECT distinct mp.organization_id

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