DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1352: financials_system_params_all fsp,

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

Line 6640: FROM financials_system_params_all fsp

6636:
6637: Cursor config_orgs_cur(p_config_item_id Number) is
6638:
6639: SELECT distinct nvl(fsp.inventory_organization_id,0) po_valid_org
6640: FROM financials_system_params_all fsp
6641: Where fsp.org_id in (select org.operating_unit
6642: from inv_organization_info_v org,
6643: mtl_system_items msi
6644: where msi.inventory_item_id = p_config_item_id