APPS.OPI_DBI_INV_TURNS_PKG dependencies on OPI_DBI_INV_TURNS_STG

Line 120: '.OPI_DBI_INV_TURNS_STG ';

116: l_stmt_num := 10;
117: IF fnd_installation.get_app_info( 'OPI', l_status,
118: l_industry, l_opi_schema) THEN
119: execute immediate 'truncate table ' || l_opi_schema ||
120: '.OPI_DBI_INV_TURNS_STG ';
121: ELSE
122: RAISE SCHEMA_INFO_NOT_FOUND;
123: END IF;
124:

Line 151: INSERT INTO OPI_DBI_INV_TURNS_STG (

147: -- are present in the cogs fact.
148: l_max_trx_date := sysdate;
149:
150: l_stmt_num := 30;
151: INSERT INTO OPI_DBI_INV_TURNS_STG (
152: ORGANIZATION_ID,
153: TRANSACTION_DATE,
154: INV_BALANCE_G,
155: INV_BALANCE_B,

Line 344: opi_dbi_inv_turns_stg turns,

340: sysdate,
341: g_user_id,
342: sysdate
343: FROM
344: opi_dbi_inv_turns_stg turns,
345: fii_time_day_all_v cal,
346: (SELECT /*+ no_merge */
347: organization_id,
348: trunc (cogs_date) cogs_date,