DBA Data[Home] [Help]

APPS.PON_GLOBAL_UPDATE_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 95: FROM mtl_system_items_kfv msi, financials_system_params_all fsp

91: WHERE auction_header_id = p_auction_header_id
92: AND line_Number in (select column_value from table(p_dest_line_ids_tbl))
93: AND NOT EXISTS -- clm_need_by_date is mandatory for planned items
94: (SELECT 'x'
95: FROM mtl_system_items_kfv msi, financials_system_params_all fsp
96: WHERE nvl(fsp.org_id, -9999) = nvl(paip.org_id,-9999) and
97: msi.organization_id = fsp.inventory_organization_id and
98: msi.inventory_item_id = paip.item_id and
99: (msi.INVENTORY_PLANNING_CODE in (1, 2) or msi.MRP_PLANNING_CODE in