143: GROUP BY c.organization_id;
144:
145: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' company inception date rows created.');
146:
147: fnd_stats.gather_table_stats(
148: ownname => g_opi_schema,
149: tabname => 'OPI_DBI_INV_VALUE_LOG',
150: percent => 10);
151: /*
835: );
836:
837: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' high water mark log rows inserted.');
838:
839: fnd_stats.gather_table_stats(
840: ownname => g_opi_schema,
841: tabname => 'OPI_DBI_INV_VALUE_LOG',
842: percent => 10);
843:
862: Get_OPM_Onhand_Balance(errbuf, retcode);
863:
864: Get_OPM_Intransit_Balance(errbuf, retcode);
865:
866: fnd_stats.gather_table_stats(
867: ownname => g_opi_schema,
868: tabname => 'OPI_DBI_OPM_INCEPTION_QTY',
869: percent => 10);
870:
871: Cost_Inception_Quantities;
872:
873: Create_Inception_Balances;
874:
875: fnd_stats.gather_table_stats(
876: ownname => g_opi_schema,
877: tabname => 'OPI_DBI_OPM_INV_STG',
878: percent => 10);
879: