DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1350: financials_system_params_all fsp,

1346:
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

Line 6616: FROM financials_system_params_all fsp

6612:
6613: Cursor config_orgs_cur(p_config_item_id Number) is
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