APPS.INV_INV_LOVS dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 628: FROM org_organization_definitions org, mtl_system_items msi

624: OPEN x_to_org_lov FOR
625: SELECT DISTINCT org.organization_id
626: , org.organization_code
627: , org.organization_name
628: FROM org_organization_definitions org, mtl_system_items msi
629: WHERE org.organization_id <> p_from_organization_id
630: AND org.organization_id = msi.organization_id
631: AND msi.inventory_item_id IN (SELECT inventory_item_id
632: FROM mtl_system_items

Line 662: FROM org_organization_definitions

658: /* SELECT DISTINCT organization_id
659: , organization_code
660: , organization_name
661: , 0
662: FROM org_organization_definitions
663: WHERE organization_code LIKE (p_organization_code)
664: ORDER BY 2; */
665: --Bug 2649387
666: SELECT distinct mp.organization_id

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