APPS.OPI_DBI_COMMON_MOD_INIT_PKG dependencies on WIP_TRANSACTIONS

Line 627: FROM wip_transactions;

623: -- Max bounds for the Actual Resource Utilization ETL
624: l_stmt_id := 70;
625: SELECT nvl (max (transaction_id), -1) + 1
626: INTO l_max_wt_plus_one
627: FROM wip_transactions;
628:
629: -- start bound for actual resource utilization ETL
630: l_stmt_id := 90;
631: SELECT /*+ index_ffs(wip_transactions) parallel_index(wip_transactions) */

Line 631: SELECT /*+ index_ffs(wip_transactions) parallel_index(wip_transactions) */

627: FROM wip_transactions;
628:
629: -- start bound for actual resource utilization ETL
630: l_stmt_id := 90;
631: SELECT /*+ index_ffs(wip_transactions) parallel_index(wip_transactions) */
632: nvl (min (transaction_id), l_max_wt_plus_one)
633: INTO l_wt_start_txn_id
634: FROM wip_transactions
635: WHERE transaction_date >= p_global_start_date;

Line 634: FROM wip_transactions

630: l_stmt_id := 90;
631: SELECT /*+ index_ffs(wip_transactions) parallel_index(wip_transactions) */
632: nvl (min (transaction_id), l_max_wt_plus_one)
633: INTO l_wt_start_txn_id
634: FROM wip_transactions
635: WHERE transaction_date >= p_global_start_date;
636:
637: -- For the Actual Resource Usage create a row:
638: -- for OPI with start_txn_id as the first transaction past global