eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on OZF_ACTIVITY_PRODUCTS

Line 312: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

308:
309: ozf_utility_pvt.write_conc_log('-- Insert into Activity Products 1 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
310:
311: FOR i in c_activity_product_family LOOP
312: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
313: parent_status, parent_type, confidential_flag,object_id,object_class, object_desc,object_status,source_code,
314: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
315: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
316: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

Line 316: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

312: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
313: parent_status, parent_type, confidential_flag,object_id,object_class, object_desc,object_status,source_code,
314: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
315: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
316: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
317: i.schedule_id, i.object_class,i.schedule_name,i.status_code,i.source_code, i.start_date_time, i.end_date_time,
318: i.owner_user_id, i.item, i.item_type,
319: i.activity_type_code, i.activity_id, i.marketing_medium_id,i.custom_setup_id,i.cust_indicator,
320: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 326: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

322:
323: ozf_utility_pvt.write_conc_log('-- Insert into Activity Products 2 --'|| to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
324:
325: FOR i in c_activity_products LOOP
326: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
327: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
328: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
329: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
330: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

Line 330: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,

326: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
327: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
328: start_date, end_date, owner_id,item,item_type, activity_type_code,activity_id, marketing_medium_id,custom_setup_id,
329: cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
330: values (ozf_activity_products_s.nextval,i.campaign_id, i.campaign_name, i.campaign_class, i.campaign_status, i.campaign_type,i.confidential_flag,
331: i.schedule_id, i.object_class,i.schedule_name,i.status_code,i.source_code, i.start_date_time, i.end_date_time,
332: i.owner_user_id, i.item, i.item_type,
333: i.activity_type_code, i.activity_id, i.marketing_medium_id,i.custom_setup_id,i.cust_indicator,
334: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 418: FROM ozf_activity_products a,ozf_activity_hl_denorm b

414: SELECT distinct a.parent_id, a.parent_desc, a.parent_class,
415: a.parent_status, a.parent_type,b.confidential_flag, a.object_id, a.object_type,a.object_status,a.object_class,
416: a.source_code, a.start_date, a.end_date, a.owner_id, b.item, b.item_type, a.activity_type_code,
417: a.activity_id, a.marketing_medium_id, a.cust_indicator
418: FROM ozf_activity_products a,ozf_activity_hl_denorm b
419: WHERE a.object_id = b.schedule_id
420: and a.object_class = 'CSCH'
421: and b.product_update_date > l_latest_comp_date;
422:

Line 430: FROM ozf_activity_products a,

426: SELECT distinct a.parent_id, a.parent_desc, a.parent_class,
427: a.parent_status, a.parent_type,b.confidential_flag, a.object_id, a.object_type,a.object_status,a.object_class,
428: a.source_code,a.start_date,a.end_date,a.owner_id,mtl.inventory_item_id item,'PRODUCT' item_type, a.activity_type_code,
429: a.activity_id, a.marketing_medium_id, a.cust_indicator
430: FROM ozf_activity_products a,
431: ozf_activity_hl_denorm b,
432: mtl_item_categories mtl,
433: eni_prod_denorm_hrchy_v eni
434: WHERE b.product_update_date > l_latest_comp_date

Line 619: --DELETE FROM ozf_activity_products_temp where object_class = 'CSCH' ;

615: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE ozf_activity_hl_denorm';
616:
617: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Temp Tables --');
618:
619: --DELETE FROM ozf_activity_products_temp where object_class = 'CSCH' ;
620: --DELETE FROM ozf_activity_customers_temp where object_class = 'CSCH' ;
621:
622: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Denorm Tables --');
623:

Line 625: delete from ozf_activity_products where object_class = 'CSCH' ;

621:
622: ozf_utility_pvt.write_conc_log('-- Full Load: Deleting from Denorm Tables --');
623:
624: delete from ozf_activity_hl_denorm;
625: delete from ozf_activity_products where object_class = 'CSCH' ;
626: delete from ozf_activity_customers where object_class = 'CSCH' ;
627:
628: initial_load(l_org_id);
629: else

Line 661: DELETE from ozf_activity_products

657: DELETE from ozf_activity_hl_denorm where activity_hl_id = i.activity_hl_id;
658:
659: if (i.item_type = 'PRODUCT') then
660:
661: DELETE from ozf_activity_products
662: WHERE item = i.item
663: AND object_id = i.schedule_id
664: AND object_class = 'CSCH';
665:

Line 668: DELETE from ozf_activity_products

664: AND object_class = 'CSCH';
665:
666: elsif (i.item_type = 'FAMILY') then
667:
668: DELETE from ozf_activity_products
669: WHERE object_id = i.schedule_id
670: AND object_class = 'CSCH'
671: AND items_category = i.item;
672:

Line 696: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

692: ozf_utility_pvt.write_conc_log('-- Adding the new product to the denorm table -- '|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss'));
693:
694: /* product_update_date is update when a new product is added during the incremental refresh */
695: FOR i in c_activity_incr_products(l_latest_comp_date) LOOP
696: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
697: parent_status, parent_type, confidential_flag,object_id,object_type,object_status,object_class, source_code,
698: start_date, end_date, owner_id, item, item_type, activity_type_code,
699: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
700: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

Line 700: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

696: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
697: parent_status, parent_type, confidential_flag,object_id,object_type,object_status,object_class, source_code,
698: start_date, end_date, owner_id, item, item_type, activity_type_code,
699: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
700: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,
701: i.parent_status, i.parent_type,i.confidential_flag, i.object_id, i.object_type,i.object_status,i.object_class,
702: i.source_code, i.start_date, i.end_date, i.owner_id, i.item, i.item_type, i.activity_type_code,
703: i.activity_id, i.marketing_medium_id, i.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
704: END LOOP;

Line 711: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

707:
708: /* Get the newly added Categories exploded into products */
709:
710: FOR i in c_activity_incr_categories(l_latest_comp_date,l_org_id) LOOP
711: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
712: parent_status, parent_type,confidential_flag, object_id,object_type,object_status,object_class, source_code,
713: start_date, end_date, owner_id, item, item_type, activity_type_code,
714: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
715: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

Line 715: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,

711: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
712: parent_status, parent_type,confidential_flag, object_id,object_type,object_status,object_class, source_code,
713: start_date, end_date, owner_id, item, item_type, activity_type_code,
714: activity_id, marketing_medium_id, cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
715: values (ozf_activity_products_s.nextval,i.parent_id, i.parent_desc, i.parent_class,
716: i.parent_status, i.parent_type,i.confidential_flag, i.object_id, i.object_type,i.object_status,i.object_class,
717: i.source_code, i.start_date, i.end_date, i.owner_id, i.item, i.item_type, i.activity_type_code,
718: i.activity_id, i.marketing_medium_id, i.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
719: END LOOP;

Line 740: DELETE from ozf_activity_products a where EXISTS

736: (select b.schedule_id
737: from ozf_activity_hl_denorm b
738: where b.schedule_status in ('CANCELLED','ARCHIVED','ONHOLD')
739: and b.schedule_id = a.object_id and a.object_class = 'CSCH');
740: DELETE from ozf_activity_products a where EXISTS
741: (select b.schedule_id
742: from ozf_activity_hl_denorm b
743: where b.schedule_status in ('CANCELLED','ARCHIVED','ONHOLD')
744: and b.schedule_id = a.object_id and a.object_class = 'CSCH');

Line 833: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

829:
830: ozf_utility_pvt.write_conc_log('-- Denorm products for new or changed schedule : ' || i.schedule_id|| '-'||to_char(sysdate,'dd-mon-yyy-hh:mi:ss') );
831:
832: FOR j in c_activity_incr_prod_new( i.schedule_id,i.list_header_id) LOOP
833: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
834: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
835: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
836: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
837: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

Line 837: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

833: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
834: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
835: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
836: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
837: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
838: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
839: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
840: j.activity_id, j.marketing_medium_id, j.item, j.item_type,
841: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);

Line 844: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,

840: j.activity_id, j.marketing_medium_id, j.item, j.item_type,
841: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);
842: END LOOP;
843: FOR j in c_activity_incr_cat_new(i.schedule_id, l_org_id,i.list_header_id) LOOP
844: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
845: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
846: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
847: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
848: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

Line 848: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,

844: INSERT into ozf_activity_products (activity_product_id,parent_id, parent_desc, parent_class,
845: parent_status, parent_type,confidential_flag, object_id,object_class, object_desc,object_status,source_code,
846: start_date, end_date, owner_id, activity_type_code,activity_id, marketing_medium_id,
847: item,item_type,cust_indicator,Last_Update_date,Last_updated_by,Creation_date,Created_by,last_update_login)
848: values(ozf_activity_products_s.nextval,j.campaign_id, j.campaign_name, j.rollup_type, j.parent_status,
849: j.campaign_type,j.private_flag, j.schedule_id, j.object_class, j.schedule_name, j.status_code,j.source_code,
850: j.start_date_time, j.end_date_time, j.owner_user_id, j.activity_type_code,
851: j.activity_id, j.marketing_medium_id, j.item, j.item_type,
852: j.cust_indicator,sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id);