DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on INV_ORGANIZATION_INFO_V

Line 1351: inv_organization_info_v org

1347: select nvl(fsp.inventory_organization_id,-99) --bugfix 2646849: 0 can be a valid orgn_id.
1348: into lPoValidationOrg
1349: from bom_cto_src_orgs bcso,
1350: financials_system_params_all fsp,
1351: inv_organization_info_v org
1352: where bcso.line_id = pLineId
1353: and bcso.create_bom = 'Y'
1354: and bcso.organization_id = org.organization_id
1355: and nvl(fsp.org_id, -1) = nvl(org.Operating_unit, -1); --bug 1531691

Line 6618: from inv_organization_info_v org,

6614:
6615: SELECT distinct nvl(fsp.inventory_organization_id,0) po_valid_org
6616: FROM financials_system_params_all fsp
6617: Where fsp.org_id in (select org.operating_unit
6618: from inv_organization_info_v org,
6619: mtl_system_items msi
6620: where msi.inventory_item_id = p_config_item_id
6621: and msi.organization_id = org.organization_id);
6622: