APPS.OPI_DBI_INV_TURNS_PKG dependencies on OPI_DBI_COGS_F

Line 135: from opi_dbi_cogs_f

131: select min(TRANSACTION_DATE) transaction_date
132: from OPI_INV_ITD_ORG_MV
133: union all
134: select min (trunc (cogs_date)) transaction_date
135: from opi_dbi_cogs_f
136: where cogs_date is not null
137: and turns_cogs_flag = 1)';
138: FETCH c_range_dates INTO l_min_trx_date;
139: CLOSE c_range_dates;

Line 249: FROM opi_dbi_cogs_f

245: (
246: SELECT DISTINCT
247: organization_id organization_id,
248: trunc (cogs_date) start_date
249: FROM opi_dbi_cogs_f
250: WHERE cogs_date is not null
251: AND turns_cogs_flag = 1
252: MINUS
253: SELECT DISTINCT

Line 352: FROM opi_dbi_cogs_f

348: trunc (cogs_date) cogs_date,
349: nvl (sum (cogs_val_b), 0) cogs_val_b,
350: nvl (sum (cogs_val_g), 0) cogs_val_g,
351: nvl (sum (cogs_val_sg), 0) cogs_val_sg
352: FROM opi_dbi_cogs_f
353: WHERE cogs_date is not null
354: AND turns_cogs_flag = 1
355: GROUP BY
356: organization_id,