[Home] [Help]
216: INSERT into ozf_activity_hl_denorm
217: (Activity_hl_id,Schedule_Id,Campaign_id,Campaign_status,Campaign_class,
218: Campaign_type,Campaign_name,Confidential_flag,Item,Item_type,List_header_id,Custom_setup_id,
219: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
220: SELECT ozf_activity_hl_denorm_s.nextval, s.schedule_id, i.campaign_id, i.status_code,
221: i.rollup_type, i.campaign_type, i.campaign_name,i.private_flag,
222: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
223: ap.level_type_code item_type, al.list_header_id,s.custom_setup_id,
224: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id
681: INSERT into ozf_activity_hl_denorm
682: (Activity_hl_id,Schedule_Id,Campaign_id,Campaign_status,Campaign_class,
683: Campaign_type,Campaign_name,confidential_flag,Item,Item_type,List_header_id,
684: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login,product_update_date)
685: SELECT ozf_activity_hl_denorm_s.nextval, Schedule_Id, Campaign_id, Campaign_status, Campaign_class, Campaign_type,
686: Campaign_name, confidential_flag,Item, Item_type, List_header_id,sysdate,null,sysdate,null,null,sysdate
687: FROM ozf_activity_hl_denorm a, ams_act_products b
688: WHERE a.schedule_id = b.act_product_used_by_id
689: AND b.arc_act_product_used_by = 'CSCH'
764: INSERT into ozf_activity_hl_denorm
765: (Activity_hl_id,Schedule_Id,Campaign_id,Campaign_status,Campaign_class,
766: Campaign_type,Campaign_name,confidential_flag,Item,Item_type,List_header_id,
767: Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login,schedule_update_date)
768: SELECT ozf_activity_hl_denorm_s.nextval, s.schedule_id, i.campaign_id, i.status_code,
769: i.rollup_type, i.campaign_type, i.campaign_name,i.private_flag,
770: decode(ap.inventory_item_id, null, ap.category_id,ap.inventory_item_id) item,
771: ap.level_type_code item_type, al.list_header_id,sysdate,null,sysdate,null,null,sysdate
772: FROM