APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 4070: mtl_system_items_b msi

4066: mmtt.transfer_lpn_id,
4067: wlpn.lpn_context
4068: FROM wms_license_plate_numbers wlpn,
4069: mtl_material_transactions_temp mmtt,
4070: mtl_system_items_b msi
4071: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4072: AND mmtt.organization_id = msi.organization_id
4073: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4074: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4088: mtl_system_items_b msi

4084: mmtt.transfer_lpn_id,
4085: wlpn.lpn_context
4086: FROM wms_license_plate_numbers wlpn,
4087: mtl_material_transactions_temp mmtt,
4088: mtl_system_items_b msi
4089: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4090: AND mmtt.organization_id = msi.organization_id
4091: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4092: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4109: mtl_system_items_b msi

4105: wlpn.lpn_context
4106: FROM wms_license_plate_numbers wlpn,
4107: mtl_material_transactions_temp mmtt,
4108: mtl_material_transactions_temp mmtt2,
4109: mtl_system_items_b msi
4110: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4111: AND mmtt2.organization_id = msi.organization_id
4112: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4113: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4153: mtl_system_items_b msi

4149: mmtt.transfer_lpn_id outer_lpn,
4150: wlpn.lpn_context
4151: FROM wms_license_plate_numbers wlpn,
4152: mtl_material_transactions_temp mmtt,
4153: mtl_system_items_b msi
4154: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4155: AND mmtt.organization_id = msi.organization_id
4156: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4157: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4170: mtl_system_items_b msi,

4166: UNION
4167: SELECT UNIQUE wlpn.license_plate_number,
4168: mmtt.transfer_lpn_id, wlpn.lpn_context
4169: FROM mtl_material_transactions_temp mmtt,
4170: mtl_system_items_b msi,
4171: wms_license_plate_numbers wlpn
4172: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4173: AND mmtt.organization_id = msi.organization_id
4174: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')

Line 4194: mtl_system_items_b msi

4190: wlpn.lpn_context
4191: FROM wms_license_plate_numbers wlpn,
4192: mtl_material_transactions_temp mmtt,
4193: mtl_material_transactions_temp mmtt2,
4194: mtl_system_items_b msi
4195: WHERE mmtt2.inventory_item_id = msi.inventory_item_id
4196: AND mmtt2.organization_id = msi.organization_id
4197: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4198: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4643: mtl_system_items_b msib

4639:
4640: CURSOR itemCur(in_lpn_id NUMBER) IS
4641: SELECT picked_quantity2
4642: FROM wsh_delivery_details wdd,
4643: mtl_system_items_b msib
4644: WHERE wdd.inventory_item_id = p_from_item_id
4645: AND wdd.inventory_item_id = msib.inventory_item_id
4646: AND wdd.organization_id = p_org_id
4647: AND wdd.organization_id = msib.organization_id

Line 4800: mtl_system_items_b msib

4796: NULL)) requested_quantity,
4797: sum(picked_quantity2) picked_quantity2,
4798: msib.primary_uom_code
4799: FROM wsh_delivery_details wdd,
4800: mtl_system_items_b msib
4801: WHERE wdd.inventory_item_id = p_from_item_id
4802: AND wdd.inventory_item_id = msib.inventory_item_id
4803: AND wdd.organization_id = p_org_id
4804: AND wdd.organization_id = msib.organization_id