APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on OPI_DBI_WMS_STOR_ITEM_CONV_F

Line 353: p_table_name - opi_dbi_wms_stor_item_conv_f for fact table,

349: Report a summary of the rates missing, and whether they are
350: inter or intra class.
351:
352: Parameters:
353: p_table_name - opi_dbi_wms_stor_item_conv_f for fact table,
354: opi_dbi_wms_stor_item_conv_stg for staging table.
355:
356: Return:
357: TRUE - if rates are missing.

Line 545: FROM opi_dbi_wms_stor_item_conv_f;

541: weight_conv_rate_type,
542: unit_volume_uom_code,
543: volume_conv_rate,
544: volume_conv_rate_type
545: FROM opi_dbi_wms_stor_item_conv_f;
546:
547: return;
548:
549: EXCEPTION

Line 568: 1. opi_dbi_wms_stor_item_conv_f

564:
565: /* setup_tables_init
566:
567: Truncate the following tables:
568: 1. opi_dbi_wms_stor_item_conv_f
569: 2. opi_dbi_wms_stor_item_conv_stg
570:
571: Clean up the run log table, OPI_DBI_CONC_PROG_RUN_LOG
572: and seed in a new row.

Line 598: 'OPI_DBI_WMS_STOR_ITEM_CONV_F');

594: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
595: 'MLOG$_OPI_DBI_WMS_STOR_ITE');
596:
597: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
598: 'OPI_DBI_WMS_STOR_ITEM_CONV_F');
599:
600: l_stmt_id := 20;
601: -- Truncate the staging table
602: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||

Line 786: INSERT /*+ append parallel (opi_dbi_wms_stor_item_conv_f) */

782: -- from and reporting UOMs, and an outer SQL that purely outer
783: -- joins to the standard conversion rates tables based on these
784: -- from and reporting UOMs.
785: --
786: INSERT /*+ append parallel (opi_dbi_wms_stor_item_conv_f) */
787: INTO opi_dbi_wms_stor_item_conv_f (
788: organization_id,
789: inventory_item_id,
790: unit_weight_uom_code,

Line 787: INTO opi_dbi_wms_stor_item_conv_f (

783: -- joins to the standard conversion rates tables based on these
784: -- from and reporting UOMs.
785: --
786: INSERT /*+ append parallel (opi_dbi_wms_stor_item_conv_f) */
787: INTO opi_dbi_wms_stor_item_conv_f (
788: organization_id,
789: inventory_item_id,
790: unit_weight_uom_code,
791: weight_conv_rate,

Line 1000: l_missing_rates := check_missing_rates ('opi_dbi_wms_stor_item_conv_f');

996: print_stage_done_mesg (l_proc_name, l_stmt_id);
997:
998: l_stmt_id := 60;
999: -- Determine if there are any missing rates, and report them.
1000: l_missing_rates := check_missing_rates ('opi_dbi_wms_stor_item_conv_f');
1001: print_stage_done_mesg (l_proc_name, l_stmt_id);
1002:
1003: l_stmt_id := 70;
1004: -- If there are missing rates, transfer the data

Line 1021: 'OPI_DBI_WMS_STOR_ITEM_CONV_F');

1017:
1018: l_stmt_id := 76;
1019: -- Commit all data by truncating the fact table.
1020: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
1021: 'OPI_DBI_WMS_STOR_ITEM_CONV_F');
1022:
1023: RAISE MISSING_RATES_FOUND;
1024:
1025: END IF;

Line 1460: opi_dbi_wms_stor_item_conv_f existing

1456: AND items.wt_rep_uom_code = wt_conv.rep_uom_code (+)
1457: AND items.volume_uom_code = vol_conv.from_uom_code (+)
1458: AND items.vol_rep_uom_code = vol_conv.rep_uom_code (+)
1459: ) all_rates,
1460: opi_dbi_wms_stor_item_conv_f existing
1461: WHERE all_rates.organization_id = existing.organization_id (+)
1462: AND all_rates.inventory_item_id = existing.inventory_item_id (+)
1463: AND ( ( existing.organization_id IS NULL
1464: AND existing.inventory_item_id IS NULL )

Line 1520: MERGE INTO opi_dbi_wms_stor_item_conv_f base

1516: l_stmt_id := 0;
1517:
1518: l_stmt_id := 10;
1519: -- Merge all data into the fact table.
1520: MERGE INTO opi_dbi_wms_stor_item_conv_f base
1521: USING
1522: (SELECT
1523: organization_id,
1524: inventory_item_id,