DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on INV_ORGANIZATION_INFO_V

Line 1912: -- inv_organization_info_v

1908:
1909: Begin
1910: -- rkaza. 3742393. 08/12/2004.
1911: -- Repalcing org_organization_definitions with
1912: -- inv_organization_info_v
1913: l_stmt_num := 120;
1914: Select operating_unit
1915: into l_operating_unit
1916: from inv_organization_info_v

Line 1916: from inv_organization_info_v

1912: -- inv_organization_info_v
1913: l_stmt_num := 120;
1914: Select operating_unit
1915: into l_operating_unit
1916: from inv_organization_info_v
1917: where organization_id = p_destination_org_id;
1918: Exception when others then
1919: l_operating_unit := null;
1920: End;

Line 4039: from inv_organization_info_v

4035: */
4036:
4037: Cursor oper_unit_cur is
4038: select distinct operating_unit organization_id
4039: from inv_organization_info_v
4040: where organization_id in (select organization_id
4041: from bom_cto_src_orgs
4042: where line_id = p_line_id
4043: and organization_type = 3);

Line 4998: from inv_organization_info_v org,

4994:
4995: lstmtNumber := 20;
4996: select distinct nvl(fsp.inventory_organization_id,0)
4997: bulk collect into l_orgs_list
4998: from inv_organization_info_v org,
4999: financials_system_params_all fsp,
5000: mtl_system_items msi
5001: where org.organization_id in (select organization_id
5002: from mtl_system_items_b