DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2915: from financials_system_params_all fsp,

2911: into l_config_exists,l_po_valid_org
2912: from mtl_system_items
2913: where inventory_item_id = p_config_item_id
2914: and organization_id = (select fsp.inventory_organization_id
2915: from financials_system_params_all fsp,
2916: po_headers_all poh
2917: where poh.po_header_id = l_doc_header_id
2918: and fsp.org_id = poh.org_id);
2919: Exception when no_data_found then

Line 4587: financials_system_params_all fsp,

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
4591: where inventory_item_id = p_config_item_id)