DBA Data[Home] [Help]

APPS.MSC_PHUB_UTIL dependencies on MSC_PHUB_ITEM_CATEGORIES_MV

Line 239: from msc_demantra_f f, msc_phub_item_categories_mv ic

235: p_aggr_type,
236: p_category_set_id,
237: nvl(ic.sr_category_id, -23453),
238: sysdate, 1, sysdate, 1, 1
239: from msc_demantra_f f, msc_phub_item_categories_mv ic
240: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
241: and f.owning_inst_id = ic.sr_instance_id(+)
242: and f.owning_org_id = ic.organization_id(+)
243: and f.inventory_item_id = ic.inventory_item_id(+)

Line 265: from msc_system_items i, msc_phub_item_categories_mv ic

261: p_aggr_type,
262: p_category_set_id,
263: nvl(ic.sr_category_id, -23453),
264: sysdate, 1, sysdate, 1, 1
265: from msc_system_items i, msc_phub_item_categories_mv ic
266: where i.plan_id=p_plan_id
267: and i.sr_instance_id = ic.sr_instance_id(+)
268: and i.organization_id = ic.organization_id(+)
269: and i.inventory_item_id = ic.inventory_item_id(+)