APPS.OPI_DBI_WMS_UTILITY_PKG dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 1487: Get the CU1 date based on the data in the WMS_DISPATCHED_TASKS_HISTORY

1483: END report_item_loc_conv_rate_err;
1484:
1485: /* set_wdth_cu1_date
1486:
1487: Get the CU1 date based on the data in the WMS_DISPATCHED_TASKS_HISTORY
1488: table. The CU1 date is the first one with transaction_temp_id not set
1489: as null.
1490:
1491: If no such date is found, then set the sysdate to be the CU1 date.

Line 1529: FROM wms_dispatched_tasks_history wdth

1525: -- Cursor to get the CU1 date from WDTH
1526: CURSOR wdth_cu1_date_csr IS
1527: SELECT /*+ parallel (wdth) */
1528: nvl (min (wdth.creation_date), sysdate)
1529: FROM wms_dispatched_tasks_history wdth
1530: WHERE transaction_temp_id IS NOT NULL;
1531:
1532: -- Audit columns
1533: l_user_id NUMBER;