DBA Data[Home] [Help]

APPS.BIV_RT_TASK_BLOG_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 621: set col12= (select substr(description,1,50) from mtl_system_items_vl i

617: ******/
618: l_pos := 'updating product';
619: begin
620: update biv_tmp_hs2 r
621: set col12= (select substr(description,1,50) from mtl_system_items_vl i
622: where i.organization_id = biv_core_pkg.g_prd_org
623: and i.inventory_item_id = r.col11)
624: where report_code = 'BIV_SERVICE_REQUEST'
625: and session_id = l_session_id;

Line 640: set col9 = (select substr(description,1,50) from mtl_system_items_vl i

636: --
637: l_pos := 'updating componet name';
638: begin
639: update biv_tmp_hs2 r
640: set col9 = (select substr(description,1,50) from mtl_system_items_vl i
641: where i.organization_id = biv_core_pkg.g_prd_org
642: and i.inventory_item_id = r.col9)
643: where report_code = 'BIV_SERVICE_REQUEST'
644: and session_id = l_session_id;

Line 659: set col13= (select substr(description,1,50) from mtl_system_items_vl i

655: --
656: l_pos := 'updating subcomponent name';
657: begin
658: update biv_tmp_hs2 r
659: set col13= (select substr(description,1,50) from mtl_system_items_vl i
660: where i.organization_id = biv_core_pkg.g_prd_org
661: and i.inventory_item_id = r.col13)
662: where report_code = 'BIV_SERVICE_REQUEST'
663: and session_id = l_session_id;