DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 171: FROM financials_system_params_all

167: BEGIN
168:
169: SELECT inventory_organization_id
170: INTO p_inventory_org
171: FROM financials_system_params_all
172: WHERE nvl(org_id, -9999) = nvl(p_org_id, -9999);
173:
174:
175: EXCEPTION

Line 2812: financials_system_params_all fsp

2808: and ip.need_by_start_date is null
2809: and ip.item_id is not null
2810: and exists ( SELECT 'x'
2811: FROM mtl_system_items_kfv msi,
2812: financials_system_params_all fsp
2813: WHERE nvl(fsp.org_id, -9999) = nvl(p_org_id,-9999)
2814: and msi.organization_id = fsp.inventory_organization_id
2815: and msi.inventory_item_id = ip.item_id
2816: and (msi.INVENTORY_PLANNING_CODE in (1, 2) or msi.MRP_PLANNING_CODE in