[Home] [Help]
795: FROM WMS_LICENSE_PLATE_NUMBERS lpn
796: , WMS_PACKAGING_HIST wph
797: , WMS_LICENSE_PLATE_NUMBERS plpn
798: , WMS_LICENSE_PLATE_NUMBERS olpn
799: , MTL_SYSTEM_ITEMS_KFV msik
800: /*Commented for bug# 6334460 start
801: , DUAL d
802: WHERE d.dummy = 'X'
803: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
905: , mtlt. hold_date
906: , mtlt.expiration_action_code
907: , mtlt.supplier_lot_number
908: FROM mtl_parameters mp
909: , mtl_system_items_kfv msik
910: , mtl_transaction_lots_temp mtlt
911: , mtl_material_transactions_temp mmtt
912: , po_hazard_classes poh
913: , mtl_material_statuses_vl mmsv
1017: , mln.hold_date hold_date
1018: , mln.expiration_action_code expiration_action_code
1019: , mln.supplier_lot_number supplier_lot_number -- invconv changes end
1020: FROM mtl_parameters mp
1021: ,mtl_system_items_kfv msik
1022: , mtl_lot_numbers mln
1023: , po_hazard_classes poh
1024: , mtl_material_statuses_vl mmsv
1025: WHERE msik.inventory_item_id = p_item_id
1230:
1231: -- The Subinventory and location information is not required for the Outbound Stuff like Pick Release
1232: -- and Pick Confirm. Hence the decode for the sub and the loc in the where clause of this cursor.
1233:
1234: SELECT /*+ ORDERED index(MMTT MTL_MATERIAL_TRANS_TEMP_U1) rowid(WPC) use_nl(WPC MMTT MSI CSG MILKFV) index(MSI MTL_SYSTEM_ITEMS_B_U1)*/
1235: wpc.organization_id organization_id
1236: , wpc.inventory_item_id inventory_item_id
1237: , wpc.revision revision
1238: , wpc.lot_number lot_number
1247: , l_secondary_uom secondary_uom -- invconv fabdi
1248:
1249: FROM wms_packaging_hist wpc
1250: , mtl_material_transactions_temp mmtt
1251: , mtl_system_items msi
1252: , cst_cost_groups ccg
1253: , mtl_item_locations milkfv
1254: -- Bug 4137707, Do not need to include this where clause,
1255: -- This will be controlled when opening this cursor