DBA Data[Home] [Help]

APPS.BIV_DBI_COLLECTION_INC dependencies on BIV_DBI_ACTIVITY_SUM_F

Line 718: update biv_dbi_activity_sum_f

714:
715: if l_from_party_tab.count > 0 then
716:
717: forall i in 1..l_from_party_tab.count
718: update biv_dbi_activity_sum_f
719: set
720: primary_flag = 'N'
721: , customer_id = l_to_party_tab(i)
722: , last_updated_by = g_user_id

Line 743: into biv_dbi_activity_sum_f a

739: ,trunc(p_collect_from_date)+(86399/86400)))
740: ,1);
741:
742: merge
743: into biv_dbi_activity_sum_f a
744: using (
745: select /*+ no_merge cardinality (stg,10) */
746: trunc(audit_date) activity_date
747: , incident_type_id

Line 865: into biv_dbi_activity_sum_f a

861: ' to ' ||
862: fnd_date.date_to_displaydt(p_collect_to_date)
863: ,1);
864: insert
865: into biv_dbi_activity_sum_f a
866: ( activity_date
867: , incident_type_id
868: , inventory_item_id
869: , inv_organization_id