DBA Data[Home] [Help]

APPS.OPI_DBI_WMS_CAPACITY_UTZ_PKG dependencies on MTL_PARAMETERS

Line 809: mtl_parameters mp

805: l_wt_rep_uom_code wt_rep_uom_code,
806: nvl (mil.volume_uom_code, C_DUMMY_UOM_CODE) volume_uom_code,
807: l_vol_rep_uom_code vol_rep_uom_code
808: FROM mtl_item_locations mil,
809: mtl_parameters mp
810: WHERE mp.wms_enabled_flag = 'Y'
811: AND mil.organization_id = mp.organization_id
812: -- filter out locators with neither capacity defined
813: AND ( ( mil.max_weight IS NOT NULL

Line 1344: mtl_parameters mp,

1340: NULL, NULL,
1341: moq.transaction_quantity)) volume_qty
1342: FROM
1343: mtl_onhand_quantities moq,
1344: mtl_parameters mp,
1345: opi_dbi_wms_curr_utz_sub_stg loc,
1346: eni_oltp_item_star items
1347: WHERE mp.wms_enabled_flag = 'Y'
1348: AND moq.organization_id = mp.organization_id