eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 102: FROM MTL_SYSTEM_ITEMS

98: x_secondary_default_ind,
99: x_secondary_uom_code,
100: x_uom_deviation_high,
101: x_uom_deviation_low
102: FROM MTL_SYSTEM_ITEMS
103: WHERE organization_id = p_organization_id
104: AND inventory_item_id = p_inventory_item_id;
105:
106: l_progress := '300';

Line 218: FROM MTL_SYSTEM_ITEMS

214: IF ( l_wms_org_flag ) THEN
215: if (p_inventory_item_id is not null) then --BUG12851446
216: SELECT NVL(ont_pricing_qty_source, G_PRICE_PRIMARY)
217: INTO l_ont_pricing_qty_source
218: FROM MTL_SYSTEM_ITEMS
219: WHERE organization_id = p_organization_id
220: AND inventory_item_id = p_inventory_item_id;
221: else
222: IF ( l_debug = 1 ) THEN

Line 328: FROM mtl_system_items

324: INTO x_ont_pricing_qty_source,
325: l_default_ind,
326: l_uom_code,
327: x_secondary_uom_code
328: FROM mtl_system_items
329: WHERE organization_id = p_organization_id
330: AND inventory_item_id = p_inventory_item_id;
331: ELSE -- not a wms org
332: IF ( l_debug = 1 ) THEN

Line 1380: , mtl_system_items msi

1376: FROM wms_license_plate_numbers wlpn
1377: , wsh_delivery_details wdd1
1378: , wsh_delivery_assignments_v wda
1379: , wsh_delivery_details wdd2
1380: , mtl_system_items msi
1381: WHERE wlpn.lpn_id = p_lpn_id
1382: AND wlpn.lpn_context = 11
1383: AND wdd1.organization_id = p_organization_id
1384: AND wdd1.lpn_id = p_lpn_id

Line 3593: FROM mtl_system_items msi,

3589: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650
3590:
3591: CURSOR wdd_item_cur (p_parent_delivery_detail_id NUMBER) IS
3592: SELECT distinct wdd.organization_id, wdd.inventory_item_id, msi.primary_uom_code, msi.secondary_uom_code
3593: FROM mtl_system_items msi,
3594: wsh_delivery_details wdd,
3595: wsh_delivery_assignments_v wda
3596: WHERE wda.parent_delivery_detail_id = p_parent_delivery_detail_id
3597: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 3683: FROM mtl_system_items msi,

3679: BEGIN
3680: SELECT 1 INTO l_temp FROM DUAL
3681: WHERE EXISTS (
3682: SELECT 1
3683: FROM mtl_system_items msi,
3684: wsh_delivery_details wdd,
3685: wsh_delivery_assignments_v wda
3686: WHERE wda.parent_delivery_detail_id = wdd_nested_lpn_rec.delivery_detail_id
3687: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 3755: FROM mtl_system_items

3751: BEGIN
3752: SELECT ont_pricing_qty_source, secondary_default_ind, primary_uom_code,
3753: secondary_uom_code, lot_control_code
3754: INTO l_pricing_ind, l_default_ind, l_pri_uom, l_sec_uom, l_lot_control_code
3755: FROM mtl_system_items
3756: WHERE organization_id = mmtt_item_rec.organization_id
3757: AND inventory_item_id = mmtt_item_rec.inventory_item_id;
3758: EXCEPTION
3759: WHEN NO_DATA_FOUND THEN

Line 3903: FROM wms_lpn_contents wlc, mtl_system_items msi

3899: ) RETURN VARCHAR2 IS
3900:
3901: CURSOR c_get_lpns (p_parent_lpn_id IN NUMBER) IS
3902: SELECT 'x'
3903: FROM wms_lpn_contents wlc, mtl_system_items msi
3904: WHERE wlc.parent_lpn_id IN ( SELECT lpn_id
3905: FROM wms_license_plate_numbers
3906: START WITH lpn_id = p_lpn_id
3907: CONNECT BY PRIOR lpn_id = parent_lpn_id)

Line 3950: mtl_system_items msi

3946:
3947: CURSOR c_get_all_wdd (p_lpn_wdd_id IN NUMBER) IS
3948: SELECT 'x'
3949: FROM wsh_delivery_details wdd,
3950: mtl_system_items msi
3951: WHERE wdd.delivery_detail_id IN (SELECT delivery_detail_id
3952: FROM wsh_delivery_assignments wda
3953: START WITH parent_delivery_detail_id = p_lpn_wdd_id
3954: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id)

Line 3981: AND (EXISTS (SELECT 1 FROM mtl_system_items msi

3977: AND wdd2.lpn_id = wlpn.lpn_id
3978: AND NVL(wlpn.CATCH_WEIGHT_FLAG,'N') = 'N') )
3979: AND wdd.inventory_item_id = NVL(p_inventory_item_id,inventory_item_id)
3980: AND wdd.container_flag = 'N'
3981: AND (EXISTS (SELECT 1 FROM mtl_system_items msi
3982: WHERE msi.inventory_item_id = wdd.inventory_item_id
3983: AND msi.organization_id = p_organization_id
3984: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
3985: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4055: , mtl_system_items msi

4051: AND wlpn.license_plate_number LIKE (p_lpn || '%')
4052: AND EXISTS ( SELECT 'x'
4053: FROM wms_license_plate_numbers wlpn3
4054: , wms_lpn_contents wlc
4055: , mtl_system_items msi
4056: WHERE wlpn3.outermost_lpn_id = wlpn.outermost_lpn_id
4057: AND wlc.parent_lpn_id = wlpn3.lpn_id
4058: AND msi.inventory_item_id = wlc.inventory_item_id
4059: AND msi.organization_id = wlc.organization_id

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 4138: , mtl_system_items msi

4134: AND NVL(wlpn2.catch_weight_flag,'N') = 'N'
4135: AND EXISTS ( SELECT 'x'
4136: FROM wms_license_plate_numbers wlpn3
4137: , wms_lpn_contents wlc
4138: , mtl_system_items msi
4139: WHERE wlpn3.outermost_lpn_id = wlpn.outermost_lpn_id
4140: AND wlc.parent_lpn_id = wlpn3.lpn_id
4141: AND msi.inventory_item_id = wlc.inventory_item_id
4142: AND msi.organization_id = wlc.organization_id

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 4260: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,

4256: , p_entry_type
4257: ) = 'Y'
4258: UNION
4259: SELECT DISTINCT license_plate_number, content_lpn_id
4260: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,
4261: wms_license_plate_numbers wlpn
4262: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4263: AND mmtt.organization_id = p_org_id
4264: AND mmtt.parent_line_id IS NULL

Line 4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

4271: ELSE
4272: IF (p_lpn_context = 8) THEN --Packing
4273: OPEN x_lpn_lov FOR
4274: SELECT distinct wlpn.license_plate_number, mmtt.content_lpn_id
4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
4276: ,wms_license_plate_numbers wlpn
4277: ,mtl_transaction_lots_temp mtlt
4278: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4279: AND mmtt.organization_id = p_org_id

Line 4370: FROM mtl_system_items_kfv msiv,

4366: , NVL(msiv.secondary_default_ind,'')
4367: , NVL(msiv.tracking_quantity_ind,'P')
4368: , NVL(msiv.dual_uom_deviation_high,0)
4369: , NVL(msiv.dual_uom_deviation_low,0)
4370: FROM mtl_system_items_kfv msiv,
4371: wms_lpn_contents wlc
4372: WHERE wlc.parent_lpn_id = p_lpn_id
4373: AND wlc.organization_id = p_org_id
4374: AND wms_catch_weight_pvt.check_ds_lpn( p_lpn_id

Line 4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc

4430: , NVL(msi.secondary_default_ind,'')
4431: , NVL(msi.tracking_quantity_ind,'P')
4432: , NVL(msi.dual_uom_deviation_high,0)
4433: , NVL(msi.dual_uom_deviation_low,0)
4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
4435: WHERE wlc.parent_lpn_id = p_lpn_id
4436: AND wlc.inventory_item_id = msi.inventory_item_id
4437: AND wlc.organization_id = msi.organization_id
4438: AND wms_catch_weight_pvt.check_wsh_lpn( p_lpn_id

Line 4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt

4484: , NVL(msi.secondary_default_ind,'')
4485: , NVL(msi.tracking_quantity_ind,'P')
4486: , NVL(msi.dual_uom_deviation_high,0)
4487: , NVL(msi.dual_uom_deviation_low,0)
4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
4489: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4490: AND mmtt.organization_id = p_org_id
4491: AND mmtt.organization_id = msi.organization_id
4492: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 4549: mtl_system_items_kfv msi

4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi
4550: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4551: AND mmtt.organization_id = p_org_id
4552: AND mmtt.organization_id = msi.organization_id
4553: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 4611: mtl_system_items_kfv msi

4607: , NVL(msi.tracking_quantity_ind,'P')
4608: , NVL(msi.dual_uom_deviation_high,0)
4609: , NVL(msi.dual_uom_deviation_low,0)
4610: FROM wms_lpn_contents wlc,
4611: mtl_system_items_kfv msi
4612: WHERE wlc.parent_lpn_id = p_lpn_id
4613: AND wlc.organization_id = p_org_id
4614: AND msi.inventory_item_id = wlc.inventory_item_id
4615: AND msi.organization_id = wlc.organization_id

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

Line 4953: mtl_system_items msi

4949: msi.primary_uom_code,
4950: msi.secondary_uom_code,
4951: msi.secondary_default_ind
4952: FROM wsh_delivery_Details wdd,
4953: mtl_system_items msi
4954: WHERE wdd.delivery_detail_id in
4955: (SELECT wda.delivery_detail_id
4956: FROM wsh_delivery_assignments_v wda,
4957: wsh_new_deliveries wnd

Line 5106: FROM mtl_system_items msi,

5102: FROM mtl_item_uoms_view
5103: WHERE organization_id = p_organization_id
5104: AND inventory_item_id = p_inventory_item_id
5105: AND uom_class IN (SELECT uom_class
5106: FROM mtl_system_items msi,
5107: mtl_units_of_measure muom
5108: WHERE msi.inventory_item_id = p_inventory_item_id
5109: AND msi.organization_id = p_organization_id
5110: AND muom.uom_code = msi.primary_uom_code)