APPS.OPI_DBI_WMS_UTILITY_PKG dependencies on INV_PROJECT

Line 497: INV_PROJECT.get_locator (mil.inventory_location_id,

493: l_locator_setup_missing_sql CONSTANT VARCHAR2 (4000) :=
494: 'SELECT
495: (orgs.name || '' ('' || mp.organization_code || '')'') org,
496: mil.subinventory_code sub,
497: INV_PROJECT.get_locator (mil.inventory_location_id,
498: mil.organization_id) loc,
499: CASE
500: WHEN mil.max_weight IS NULL OR
501: mil.location_weight_uom_code IS NULL THEN

Line 527: INV_PROJECT.get_locator (mil.inventory_location_id,

523: OR mil.volume_uom_code IS NULL)
524: ORDER BY
525: (orgs.name || '' ('' || mp.organization_code || '')''),
526: mil.subinventory_code,
527: INV_PROJECT.get_locator (mil.inventory_location_id,
528: mil.organization_id)';
529:
530: BEGIN
531:

Line 1086: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)

1082: CURSOR missing_vol_conv_csr IS
1083: SELECT
1084: (orgs.name || ' (' || mp.organization_code || ')') org,
1085: stg.subinventory_code sub,
1086: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)
1087: loc,
1088: stg.volume_uom_code
1089: FROM opi_dbi_wms_curr_utz_sub_stg stg,
1090: mtl_parameters mp,

Line 1100: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id);

1096: AND stg.volume_capacity_rep < 0
1097: ORDER BY
1098: (orgs.name || ' (' || mp.organization_code || ')'),
1099: stg.subinventory_code,
1100: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id);
1101:
1102: -- Report all missing weights at the locator level.
1103: CURSOR missing_wt_conv_csr IS
1104: SELECT

Line 1107: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)

1103: CURSOR missing_wt_conv_csr IS
1104: SELECT
1105: (orgs.name || ' (' || mp.organization_code || ')') org,
1106: stg.subinventory_code sub,
1107: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)
1108: loc,
1109: stg.weight_uom_code
1110: FROM opi_dbi_wms_curr_utz_sub_stg stg,
1111: mtl_parameters mp,

Line 1121: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id);

1117: AND stg.weight_capacity_rep < 0
1118: ORDER BY
1119: (orgs.name || ' (' || mp.organization_code || ')'),
1120: stg.subinventory_code,
1121: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id);
1122:
1123: -- Cursor to get the reporting UOM.
1124: CURSOR get_rep_uom_csr (p_measure_code IN VARCHAR2)
1125: IS