APPS.OPI_DBI_WMS_UTILITY_PKG dependencies on MTL_ITEM_LOCATIONS

Line 478: mtl_item_locations mil

474: CURSOR loc_setup_missing_count_csr IS
475: SELECT
476: count (*)
477: FROM mtl_parameters mp,
478: mtl_item_locations mil
479: WHERE mp.organization_id = mil.organization_id
480: AND mp.wms_enabled_flag = 'Y'
481: AND mp.process_enabled_flag <> 'Y'
482: AND ( mil.max_weight IS NULL

Line 514: mtl_item_locations mil,

510: ELSE
511: 0 /*C_NOTHING_MISSING*/
512: END vol_missing_flag
513: FROM mtl_parameters mp,
514: mtl_item_locations mil,
515: hr_all_organization_units_vl orgs
516: WHERE mp.organization_id = orgs.organization_id
517: AND mp.organization_id = mil.organization_id
518: AND mp.wms_enabled_flag = ''Y''