DBA Data[Home] [Help]

APPS.CTO_AUTO_PROCURE_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 3300: from financials_system_params_all fsp,

3296: into l_config_exists,l_po_valid_org
3297: from mtl_system_items
3298: where inventory_item_id = p_config_item_id
3299: and organization_id = (select fsp.inventory_organization_id
3300: from financials_system_params_all fsp,
3301: po_headers_all poh
3302: where poh.po_header_id = l_doc_header_id
3303: and fsp.org_id = poh.org_id);
3304: Exception when no_data_found then

Line 4999: financials_system_params_all fsp,

4995: lstmtNumber := 20;
4996: select distinct nvl(fsp.inventory_organization_id,0)
4997: bulk collect into l_orgs_list
4998: from inv_organization_info_v org,
4999: financials_system_params_all fsp,
5000: mtl_system_items msi
5001: where org.organization_id in (select organization_id
5002: from mtl_system_items_b
5003: where inventory_item_id = p_config_item_id)