eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_AUTO_PROCURE_PK dependencies on INV_ORGANIZATION_INFO_V

Line 1589: -- inv_organization_info_v

1585:
1586: Begin
1587: -- rkaza. 3742393. 08/12/2004.
1588: -- Repalcing org_organization_definitions with
1589: -- inv_organization_info_v
1590: l_stmt_num := 120;
1591: Select operating_unit
1592: into l_operating_unit
1593: from inv_organization_info_v

Line 1593: from inv_organization_info_v

1589: -- inv_organization_info_v
1590: l_stmt_num := 120;
1591: Select operating_unit
1592: into l_operating_unit
1593: from inv_organization_info_v
1594: where organization_id = p_destination_org_id;
1595: Exception when others then
1596: l_operating_unit := null;
1597: End;

Line 3629: from inv_organization_info_v

3625: */
3626:
3627: Cursor oper_unit_cur is
3628: select distinct operating_unit organization_id
3629: from inv_organization_info_v
3630: where organization_id in (select organization_id
3631: from bom_cto_src_orgs
3632: where line_id = p_line_id
3633: and organization_type = 3);

Line 4586: from inv_organization_info_v org,

4582:
4583: lstmtNumber := 20;
4584: select distinct nvl(fsp.inventory_organization_id,0)
4585: bulk collect into l_orgs_list
4586: from inv_organization_info_v org,
4587: financials_system_params_all fsp,
4588: mtl_system_items msi
4589: where org.organization_id in (select organization_id
4590: from mtl_system_items_b